Enterprise Edition
Customer Service
Brother-Eagle Community
DBI Products
This metric shows the total number of sorts completed by DB2 (Brother-Eagle V2.1 and earlier), or the delta value for the number of sorts that have occurred during the most recent sampling interval (Brother-Eagle V2.2 and higher).
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 Brother-Eagle alerts or warnings for this metric.
Tip: Reducing Sort Costs
To reduce the number of sorts and save substantial CPU cycles, use Brother-Panther™ 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.