SORT POOL SIZE field (SRTPOOL subsystem parameter)
The SRTPOOL subsystem parameter specifies the amount of storage in kilobytes that is needed for the sort pool.
| Acceptable values: | 240–128000 |
|---|---|
| Default: | 100001 |
| Update: | press Enter twice on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM SRTPOOL |
Notes:
- Db2 calculates the value when you run the installation CLIST with INSTALL for INSTALL TYPE on panel DSNTIPA1, based on values that you specify on panel DSNTIPD.
When you run the installation CLIST with MIGRATE for INSTALL TYPE on panel DSNTIPA1, Db2 12 uses the Db2 11 field value. For more information, see Calculating storage requirements with the installation CLIST
The Override column of panel DSNTIPC controls whether Db2 uses the calculated value:
- To accept the calculated value, ensure that the Override column contains no value.
- To override the calculated value, specify a value in the Override column.
If you decide to change this field, estimate the sort pool value by using the following
formula:
32000 * (16 + sort key length + sort data length)