Spotlight on DB2 6.10 - Getting Started Guide

Hash Join Small Overflows

The number of times that a hash join overflowed available sort heap space by less than 10%. If this number and the number of hash join overflows are both high, try increasing SHEAPTHRES parameters. If the small overflows number is more than 10% of the number of hash join overflows, try increasing the sort heap size.

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.