RE: [SYS21] Access path problems...

["Paul Crabtree" <PCrabtree@xxxxxxxxxx>]

We had this problem, we did this:

CHGPF FILE(FILELIB/FILENAME) ACCPTHSIZ(*MAX1TB) 

After the command executes, the system will begin rebuilding the access
path (Check EDTRBDAP for time estimate and status).

Paul


-----Original Message-----
From: Eva SooHoo [mailto:EvaS@circacorp.com] 
Sent: Monday, January 13, 2003 11:44 AM
To: JBAUSERS-L@midrange.com
Subject: [SYS21] Access path problems...


Checked the archives and found this discussion on Access Paths
rebuilding everytime a program option is run.  We are having this same
problem with Routes/Structures maintenance.  Please excuse my ignorance,
but what is the remedy if to the situation if the 'ACCPTHSIZ parameter
is *MAX4GBand it is full."  In other words, how do I fix this problem?
 
 
Thanks for any help that you can provide.
 
Previous thread:
 
RE: Access Path rebuilding even though *IMMED ?
 
------------------------------------------------------------------------
----
----
 
Subject: RE: Access Path rebuilding even though *IMMED ? 
From: "Heffner, Art" <AHeffne@xxxxxxxxxxxxx> 
Date: Thu, 1 Mar 2001 09:23:28 -0500 
 
------------------------------------------------------------------------
----
----
 
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.
                +---
 
 
 
************************************************************************
Eva SooHoo
Management Information Systems, Circa Corporation
Internet: EvaS@CircaCorp.com
Phone 415/822-1600 ext. 208,   Fax: 415/822-1700