Spotlight on DB2 6.9.3 - Getting Started Guide

Percent of Sort Heap Threshold alarm

The Percent of Sort Heap Threshold alarm becomes active when the amount of sort heap space allocated approaches or exceeds the SHEAPTHRES database manager configuration parameter value. The SHEAPTHRES parameter value is the sort heap threshold for the entire instance.

The underlying metrics for this alarm can be adjusted to suit your environment by using the Metric Editor.

What you can do

• Determine whether the current SHEAPTHRES parameter value is appropriate for your system. Insufficient sort heap allocation causes the database manager to select less efficient sorting techniques that can severely impact system performance.

• Access the Client Applications and Databases drilldowns.

  • The Sorting tab in both drilldowns can help you profile the sorting requirements and sort exception rates at the instance, database, and application levels.
  • The Details tab can help you identify databases and applications that are consuming significant amounts of CPU time to perform sorts.

Related topics

Metric Editor

What are thresholds and severities?