MAX IN-MEMORY SORT SIZE field (MAXSORT_IN_MEMORY subsystem parameter)
The MAXSORT_IN_MEMORY subsystem parameter specifies the maximum allocation of storage in kilobytes for a query that contains an ORDER BY clause, a GROUP BY clause, or both. The storage is allocated only during the processing of the query. Increasing the value in this field can improve performance of such queries but might require large amounts of real storage when several such queries run simultaneously.
| Acceptable values: | 1000 to the value specified in SORT POOL SIZE, whichever is larger |
|---|---|
| Default: |  2000 1 |
| Update: | press Enter twice on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM MAXSORT_IN_MEMORY |
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 13 uses the Db2 12 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.