RE: Üsing Logicals?

[Walden Leverich <walden@xxxxxxxxxxxxxxx>]

Tim,

Two observations:

1) Create the new logical. This will result in OS/400 creating a new index 
on City/State/Zip/2-Digit Code. Then delete are recreate the existing 
logical keyed by City and State. This will result in OS/400 sharing the 
index of the City/State/Zip... index when it creates the City/State index. 
Result: 2 logical files, but only ONE index to maintain. Technically you 
can do this by removing and readding the logical file member, but I find 
the delete/create step easier. Also, I assume that in the old logical file 
you do not specify a FIFO, FILO, FCFO, or any other ordering options. If so 
index sharing won't work. When you are done check the object size of the 
two logicals, you will see one rather large file and one file that is about 
10K.

2) By the looks of it this is a rather static file. (Zip codes don't change 
THAT often) Therefore, who cares how many indices there are on the file. 
Index maintenance hurts at update time, not read time.

Hope this helps.
-Walden

-------------------------------
Walden Leverich
Tech Software
walden@techsoftinc.com
www.techsoftinc.com

-----Original Message-----
From:   Tim Truax [SMTP:truax@usaor.net]
Sent:   Sunday, November 02, 1997 11:01 PM
To:     MIDRANGE-L@midrange.com
Subject:        Re: Üsing Logicals?

John Carr wrote:
> So why are you against another logical?  How many do you have over the
> PF?  10?  50?

I am concerned that too many logicals cause the system to expend alot of
process to overhead issues in maintaining the *IMMED access.  This file
has about 25000 records and about 18 logicals currently.

> What does the Key look like?  (No select/omits ?)

No select/omits it will be the City/State/zip/2 digit record ranking/
about 40 positions long, the other one is just city/state, and was
created several years ago and is used in many programs.  Maybe I should
just change the original?


--
''''''''''''''''''''
:-Tim & Dana Truax-:
....................
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: 
david@midrange.com
+---
umidr
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---