Chat now with support
Chat with Support

Spotlight on DB2 6.10 - Getting Started Guide

Hash Join Overflows

The number hash joins that ran out of sort heap space. Increasing the SHEAPTHRES for the instance or the SORTHEAP for the database or partition can reduce the overflow rate.

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