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

You do not want to have the system rebuild the access paths!  It has to
re-read the entire physical file, and you don't want that to happen.  It
takes longer to copy the file, but when you are done, you are done. 
Otherwise, you have to wait for the access paths to be rebuilt, and with
a large file, that takes quite a bit of time.  Especially on a smaller system.
-Bob

> Simone Pacciarini wrote:
> 
> 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
> +---
+---
| 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
+---