Chat now with support
Chat with Support

Spotlight on DB2 6.10 - Getting Started Guide

Post Threshold Joins

The total number of hash joins that requested sort heaps after the sort heap threshold (SHEAPTHRES) was reached. (Consequently, these joins are allotted limited amounts of sort heap space.) A high number might indicate a need for larger SHEAPTHRES value.

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