4K SORT PRIMARY SPACE field
The value of the 4K SORT PRIMARY SPACE field specifies the total amount of space for all 4 KB sort work table spaces in the work file database. This value is specified in MB, but you can enter the value in GB by specifying a suffix of G, for example 1024G.
Unlike temporary work table spaces, sort work table spaces are always segmented table spaces and cannot increase in size.
| Acceptable values: | for installation: 1–32,702,464; for migration: 0–32,702,464 |
|---|---|
| Default: | for installation: 20; for migration: 0 |
| Update: | none |
| DSNZPxxx: | none |
The value of the 4K SORT PRIMARY SPACE field is divided by the value of the 4K SORT WORK TS’S field to determine the primary space quantity (PRIQTY) for creating each 4 KB type sort work file table space. For example, if you specify a value of 16 for the 4K SORT PRIMARY SPACE field and a value of 4 for the 4K SORT WORK TS’S field, the PRIQTY for each 4 KB type table space is 4096 KB.
The secondary space quantity (SECQTY) value for each 4 KB type table space is always 0.
If you run the CLIST in MIGRATE mode, the value of the 4K SORT PRIMARY SPACE field is used only when additional 4 KB type sort work file table spaces are created. Db2 does not take into account the space that is already used by existing 4 KB type work files.