Access path size (ACCPTHSIZ)

Specifies the maximum size of auxiliary storage that can be occupied by access paths that are associated with join logical files or with files that have keyed sequence access paths.

For optimum performance, consider whether there is high contention for keys within the access path when selecting this value:

Note:
For a join logical file, this parameter applies to all join secondary access paths even if the join logical file is not a keyed file.

The possible values are:

*MAX4GB
The access paths associated with this file can occupy a maximum of four gigabytes (4,294,966,272 bytes) of auxiliary storage. This value provides compatibility with releases of the operating system earlier than Version 3 Release 6 Modification 0.

*MAX1TB
The access paths associated with this file can occupy a maximum of one terabyte (1,099,511,627,776 bytes) of auxiliary storage.

This value is not supported on releases of the system earlier than Version 3 Release 6 Modification 0 (V3R6M0). Therefore, if a physical file that has this attribute is saved, and the save operation specifies a target release earlier than V3R6M0, the access paths are not saved. If this saved version of the file is then used to restore the physical file, the system rebuilds all of the access paths.

*CMDDFT
The system default is used.