DB2 Version 9.7 for Linux, UNIX, and Windows

hash_join_small_overflows - Hash Join Small Overflows monitor element

The number of times that hash join data exceeded the available sort heap space by less than 10%.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Basic
Application	appl	Basic

For snapshot monitoring, this counter can be reset.

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Database	event_db	-
Connection	event_conn	-

Usage: If this value and hash_join_overflows are high, then you should consider increasing the sort heap threshold. If this value is greater than 10% of hash_join_overflows, then you should consider increasing the sort heap size.