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

I don't see the reason for your approach (too much work).  When I decided to 
upgrade our LF's to ACCPTHSIZ *MAX1TB, I created a PDM user option to do just 
that with the CHGLF command, and ugraded them in groups, by name, over 3 
weekends.  There were thousands of access paths, with quite a few referring to 
tens of millions of records.  For the vast majority of them there was no 
rebuild of the access path (ie. instant conversion), irrespective of the size 
of the access path.  This was done on a 12-way box with 96 gig main storage 
within 1 interactive job (ie. using only one of the processors).  -DaveK

> 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 message was sent through IDT.
http://www.idt.net/


+---
| 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
+---