DB2 Version 9.7 for Linux, UNIX, and Windows
active_hash_joins - Active hash joins
monitor element
The total number of hash joins that are currently running and consuming memory.
Table 1. Snapshot Monitoring Information
Snapshot Level
Logical Data Grouping
Monitor Switch
Database
dbase
-
Parent topic:
Database system monitor elements
Related concepts
:
Tuning sort performance
Related reference
:
post_shrthreshold_hash_joins - Post threshold hash joins monitor element
DB2 Version 9.7 for Linux, UNIX, and Windows
DB2 Version 9.7 for Linux, UNIX, and Windows