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

[Bob Buchanan <BobbyB@xxxxxxxxxxx>]

The question was the FASTEST way to have ALL of them rebuilt.

While your approach was probably appropriate for your installation, not
all of us are blessed with access to such a generous system.

-Bob 

dkeck@idt.net wrote:
> 
> 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
+---
| 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
+---