4K TEMP WORK TS'S field

The value of the 4K TEMP WORK TS'S field specifies the number of 4 KB temporary 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 when new 4 KB type temporary work file table spaces are created. Db2 does not take into account the number of existing 4 KB type temporary work file table spaces.