SORTFSZ control statement
The SORTFSZ control statement selects striped sort mode or specifies large sort volumes for sequential scan. SORTFSZ will trigger striped sort mode, the value that is entered will be used to determine the size of the sort stripes.
When writing index record to a stripe to be used as sort input file, reaching this number would cause the stripe to be closed, and a new stripe is opened to continue the process.
The SORTFSZ value is also used for stripe allocation. Values lager than 500,000 are accepted, else the default of 2000000 is used.
SORTFSZ is used in the internal sorts of the scan.
SORTFSZ also selects striped sorts when the indexes have been deleted and defined, even if they are defined as REUSE.
The number nnnnnnnnn
is never passed to sort as an estimate of the number of records in
the index.
- For striped sorts, the number nnnnnnnnn is used only to decide the size of the stripes if striped sort is selected.
- For sequential scan, the number nnnnnnnnn is passed to sort as an estimate of the number of records in internal sort associated with the scan.
- SORTFSZ
- Specifies that this is a SORTFSZ statement
- nnnnnnnnn
- An integer in the range of 1 - 999999999.