Re: Access Path rebuilding even though *IMMED ?

Thanks Art, I'll get on case, this one has stumped the whole department!

Andy
----- Original Message -----
From: Heffner, Art <AHeffne@PTS-TOOLS.COM>
To: <JBAUSERS-L@midrange.com>
Sent: Thursday, March 01, 2001 2:23 PM
Subject: RE: Access Path rebuilding even though *IMMED ?


> I would bet the rebuild is done because the ACCPTHSIZ parameter is *MAX4GB
> and it is full.
>
> Art Heffner - Production Tool Supply
>
> -----Original Message-----
> From: andy.jeffery [mailto:andy.jeffery@ntlworld.com]
> Sent: Wednesday, February 28, 2001 7:05 PM
> To: JBAUSERS-L@midrange.com
> Subject: Access Path rebuilding even though *IMMED ?
>
> Our G/L LF GLBLTRAN keeps attempting to rebuild the access
> path everytime we
> use Reversing Journals, just what we needed at Period End.
>
> I've checked the LF Definition and it's *IMMED so why is it
> being rebuilt?
> The file has not been restored in anyway.  Unfortunately the
> LF has 21
> Million Indexes.
>
> Any help would be much appreciated!
> Thanks in advance.
> Andy
>
>
> +---
> | This is the JBA Software Users Mailing List!
> | To submit a new message send your mail to
> JBAUSERS-L@midrange.com.
> | To subscribe to this list send email to
> JBAUSERS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> JBAUSERS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner:
> doug333@aol.com.
> +---
>
> +---
> | This is the JBA Software Users Mailing List!
> | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
JBAUSERS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: doug333@aol.com.
> +---
>

+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---