SORTSCHEME

To increase performance of a SORT operation, configure SORT to retain more of the record information in memory.

You should consider setting this environment variable if the total size of files in your SORT operation is over 1GB.

Parameters

0

During a SORT operation, temporary files are created to hold the non-key data portions of a record that are greater than 1024 bytes.

1

During a SORT operation, non-key data portions of a record are held in memory depending on the size of SORTSPACE:

Size of SORTSPACE	Maximum non-key data portion held in memory
1MB or greater	5KB
4MB or greater	12KB
8MB or greater	28KB
16MB or greater	62KB

Note: In general, the non-key data portion is the size of the record minus the size of the key data.

The default value is 0.

SORTSCHEME=1