Re: Logical Files vs. Physical Keys

Yes I was told this very same thing on the Sys/38

______________________________________________
Eric N. Wilson
President
Doulos Software & Computer Services
2913 N Alder St.
Tacoma WA 98407


----- Original Message -----
From: "Bruce Collins" <bacollins@twitchellcorp.com>
To: <MIDRANGE-L@midrange.com>
Sent: Thursday, March 23, 2000 6:41 AM
Subject: RE: Logical Files vs. Physical Keys


> The reason we only access thru logical files is if a logical file gets
> damaged (which did occur when we were on V2R3) then we delete it and
> recreate it. If a physical file gets damaged then the chance for data loss
> is great. An IBMer had told us at that time, it could be fixed now, that a
> program accessing the file,either IBM or User written, could corrupt the
> object. an IBMer recommended this way and we have not had any problems.
IMHO
>
> Bruce Collins
> Twitchell Corporation
> bacollins@twitchellcorp.com
>
> "People who think they know everything really annoy those of us who do!"
>
> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of Bob Entwistle
> Sent: Wednesday, March 22, 2000 5:16 PM
> To: MIDRANGE-L@midrange.com
> Subject: Logical Files vs. Physical Keys
>
>
>
>
> When we started out on the AS400 11 years ago, a decision was made to
always
> use
> logical files and never use physical keys (index) on all of our files.  At
> this
> point, this is being reevaluated and no one seems to remember why physical
> keys
> were seen as a bad thing.
>
> Anyone able to give a short synopsis of the tradeoffs between the two?
Any
> downsides to using physical keys or indexes?
>
> Bob
>
>
>
>
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---