Chat now with support
Chat with Support

Spotlight on DB2 6.10 - Getting Started Guide

Post Threshold Sorts

The total number executed sorts that requested sort heaps after the sort heap threshold (SHEAPTHRES) was reached. (These sorts are allocated a sort heap smaller than the SORTHEAP value.) A high number might indicate a need for a larger SHEAPTHRES value or for fewer or smaller sort requests.

Note: In a multiple-partition database, information is presented for each active partition on the system. An All Nodes row keeps a running total for all partitions. In a single-partition database, only the All Nodes information is presented.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating