Chat now with support
Chat with Support

Spotlight on DB2 6.9.3 - Getting Started Guide

Post Threshold Sorts alarm

The Post Threshold Sorts alarm becomes active when a sort has been requested after the sort heap threshold has been reached. Sorts that start after the sort heap threshold (sheapthres configuration parameter) has been reached may not receive all the memory they need to run efficiently. By adjusting the sort heap threshold and sort heap size configuration parameters, you can improve sort operations and overall system performance.

This alarm has been predefined with a Low severity level. The underlying metric for this alarm can be adjusted to suit your environment by using the Metric Editor.

What you can do

If post-threshold sort values are high, you can try the following possible solutions:

  • Increasing SHEAPTHRES

  • Making SQL query changes that allow applications to use fewer or smaller sorts.


Related topics

Metric Editor

What are thresholds and severities?

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating