32K SORT PRIMARY SPACE field
The value of the 32K SORT PRIMARY SPACE field specifies the total amount of space for all 32 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 32K SORT PRIMARY SPACE field is divided by the value of the 32K SORT WORK TS’S field to determine the primary space quantity (PRIQTY) for creating each 32 KB type sort work file table space. For example, if you specify a value of 16 for the 32K SORT PRIMARY SPACE field and a value of 4 for the 32K SORT WORK TS’S field, the PRIQTY for each 32 KB type table space is 4096 KB.
The secondary space quantity (SECQTY) value for each 32 KB type table space is always 0.
If you run the CLIST in MIGRATE mode, the value of the 32K SORT PRIMARY SPACE field is used only when additional 32 KB type sort work file table spaces are created. Db2 does not take into account the space that is already used by existing 32 KB type work files.