Good guess Simon.  According to IBM ...

"In R410, the default for Access path size (ACCPTHSIZ) changed to *MAX1TB
rather than *MAX4GB on the CRTLF and CRTPF commands and in the SQL CREATE
INDEX statement. Most existing access paths have an attribute of *MAX4GB.
These access paths cannot be shared by access paths with an attribute of
*MAX1TB. For access path sharing to occur, change existing access paths to
ACCPTHSIZ(*MAX1TB) or specify ACCPTHSIZ(*MAX4GB) on the new access paths."

Reference the following multi-line URL:

-Dave K.

----- Original Message -----
From: "Simon Coulter" <>
To: <>
Sent: Thursday, January 03, 2002 8:05 PM
Subject: Re: ACCPTHSIZ perfomance - *MAX1TB vs *MAX4GB

> Hello Phil,
> You wrote:
> [SNIP]
> >logicals related to a physical should be 1TB or 4GB, but do not mix
> >them.  It refers to performance issues if you mix them, but it is not
> >clear if they are referring to overall performance, or performance in a
> >specific program.
> My guess is that since 4GB and 1TB indices are physically different in
> structure you would reduce the likelyhood of sharing access paths and
> could thus experince poor performance when adding or deleting records or
> when updating key values in existing records due to the extra access
> paths.
> Regards,
> Simon Coulter.
> --------------------------------------------------------------------
>    FlyByNight Software         AS/400 Technical Specialists
>    Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
>    Fax:   +61 3 9419 0175   mailto:   \ /
>                                                              X
>                  ASCII Ribbon campaign against HTML E-Mail  / \
> --------------------------------------------------------------------
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> To post a message email:
> To subscribe, unsubscribe, or change list options,
> visit:
> or email:
> Before posting, please take a moment to review the archives
> at

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.