Chat now with support
Chat with Support

Spotlight on DB2 6.10 - Release Notes

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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating