This metric shows the currently allocated amount of private SORTHEAP memory in 4K pages. If DB2 autonomic tuning is enabled, you may observe increases or decreases in the amount of SORTHEAP memory. Increases in the amount of SORTHEAP memory may indicate that DB2 is doing increasing amounts of sorting, or sorting larger result set sizes. The presence of sorting often indicates the need to perform additional physical design tuning to reduce the number of sorts.
By default, there are no warnings for this metric.
Tip: Reducing Sort Costs
To improve sort performance, use the statistics to identify the statements having the highest aggregate sort time costs. Create clustering indexes to reduce sort costs, or convert the table to an MDC table if appropriate.