Nanda,
I HAD to change the ACCPTHSIZ parameter on some files and their logicals to
the larger index size, due to performance degradation. We have a couple of
files in the 25 million record range, and when multiple WW's were building
indexes over the files, while concurrent interactive users were updating
those files, the interactive users performance would drop measurably. At
times, they appeared to be locked up, it was so slow.
I have not seen a big difference in size as a result of these changes.
However, I have a 400 G system, so I do have a lot of space to work with.
Chuck
----- Original Message -----
From: "nanda" <
[email protected]>
To: <
[email protected]>
Sent: Wednesday, November 22, 2000 4:35 AM
Subject: Access Path Size ACCPTHSIZ ~~0:1550
> Does anyone have any experience of changing the ACCPTHSIZ parameter from
the
> default *MAX4GB to *MAX1TB?
>
> In theory this could improve performance and seems ot be the
recommendation
> of IBM. However it would appear that there might be a downside as far as
> dasd and memory requirements are concerned.
>
> Any experience - positive or otherwise - welcomed!
>
> Regards
> Nanda
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=1
550
> *************************************************************
> This is the JDEList World Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at
http://www.JDELIST.com
> *************************************************************
>
>