RE: Help!!!!! Access path size

[Chris Bipes <chris.bipes@xxxxxxxxxxxxxxx>]

Create a new library and compile the new logicals into it pointing to the
existing physical.  Make sure you set your access path size to be what you
want.  Now when you can get an exclusive lock on the LF in production,
delete it and move the new one into production.  The move only takes a
fraction of a second.

Choice two, create a physical in the new library and start mirroring the two
files via triggers on the production copy.  Write a program to read all the
records from production and write/update the new copy.  Create all the LF in
the new library after you have the files in sync.  When you can get your
exclusive lock on the production physical, move it and all the logicals to a
third library in NO library list and move the new copies into production.
Verify the data is in sync and delete the old copies.

Hope you have the DASD to do all this.  By the way, is the physical keyed?
If so, can you create a logical with the same key, yet the correct access
path size?  This will enable access path sharing when you convert the PF to
use the new access path size thus be a real fast change.  When done, you can
delete the duplicate LF.

Hope this helps,



Christopher K. Bipes    mailto:ChrisB@Cross-Check.com
Sr. Programmer/Analyst  mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.        http://www.cross-check.com
6119 State Farm Drive   Phone: 707 586-0551 x 1102
Rohnert Park CA  94928  Fax: 707 586-1884

If consistency is the hobgoblin of little minds, only geniuses work here.
Karen Herbelin - Readers Digest 3/2000
> cjimenez@wlgore.com wrote:
> 
> We need to know the fastest possible way to convert the access path
> size
> attribute on an 16GB file that has over 50 logicals attached to it
> with an
> additional 45GB. What method do you know and how long do you think it
> will take.
> I will appreciate any and all input regarding this task.
+---
| 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
+---