This metric shows the total number of sorts completed by DB2, or the delta value for the number of sorts that have occurred during the most recent sampling interval.
Sorts are expensive, even small sorts that do not overflow the SORTHEAP memory. 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 alerts or warnings for this metric.
Tip: Reducing Sort Costs
To reduce the number of sorts and save substantial CPU cycles, 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.