32K SORT WORK TS'S field

The value of the 32K SORT WORK TS'S field specifies the number of 32 KB sort work file table spaces that are to be created.

Acceptable values: for installation: 1–499; for migration: 0–500
Default: for installation: 1 for migration: 0
Update: none
DSNZPxxx: none

The sum of the values of the 4K SORT WORK TS’S field, the 32K SORT WORK TS’S field, the 4K TEMP WORK TS’S field, and the 32K TEMP WORK TS’S field cannot exceed 500.

If you run the CLIST in MIGRATE mode, and you enter a non-zero value, the value is used for creating new 32 KB type sort work file table spaces. Db2 does not take into account the number of existing 32 KB type sort work file table spaces.