SORTPOOL—Sort pool size
Use the Modify Sortpool Size panel or the SORTPOOL command to specify the amount of storage needed for the sort pool. The sort pool value is used by Db2 as the maximum size of a sort area allocated when a cursor is opened for a SELECT statement that requires sorting.
Because the size of the sort pool can affect sort efficiency, you can improve performance by using SORTPOOL to allow each concurrent sort user a larger sort area.
Modify Sortpool Size panel
Command ===> _________________________________________________________________
Command: CURRENT
Description . . . . . . . . : SORTPOOL SIZE PARAMETER
Type the new sortpool size value that you wish to change to. Then press Enter. The value can also be specified in megabytes (M), kilobytes (K) or in bytes (B), but must be a multiple of 1K.
Sortpool Parameter
Sortpool size . . . . . . . (240K-64000K or delta)
Command syntax and parameters
Value | Description |
|---|---|
DB2ssid | Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies. |
opertuneID | OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job). |
value | Sort pool size (the maximum size of a sort area allocated when a cursor is opened for a SELECT statement that requires sorting). Specify one of the following values:
*This value can also be specified in bytes (B) or megabytes (M), but the value specified must be a multiple of 1K. |
NORESET | The changes you request remain in effect until the Db2 subsystem is cycled. |
Db2 parameter values
Field | Installation panel | CLIST parameter | ZPARM macro | ZPARM parameter |
|---|---|---|---|---|
Sortpool Size | DSNTIPC | SORTPOOL | DSN6SPRM | SRTPOOL |