Rif: Re: Help!!!!! Access path size

[Simone Pacciarini <spacciarini@xxxxxxxxx>]

I would add 3 steps:

1A) Change all logicals to be access path maintenance
*DLY
2A) Change back the logicals to *IMMED
2B) Open the logicals with a pgm and let them rebuild
the acces path.

This looks to me to be a little bit faster. We
experienced a copy of a 25Gb indexed PF to an empty
one with 4 LF attached to it, without making those
logicals to be *DLY and it really was a bloody bath.

Simone Pacciarini
_____________________________________________________
The fastest possible way to convert the access paths
(from the time you
start until all are done) is to do the following:

1) Create a blank set of physical/logical files with
the attributes you want.

2) Create an RPG program or REXX script to read from
the old file into
the new file and run it.  CPYF will not produce the
results you want, as
it invalidates and rebuilds the logicals

3) Replace the old files with the new files.

This is the fastest beginning to end because all the
indexes are updated
as records are added to the file.  Any other method
will read all the
records in the physical file up to 50 times.  It may
be less due to
access path sharing, but it isn't likely to be much
less.


__________________________________________________
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.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
+---