Hash Join Threshold


 
Snapshot Level
Database Manager

 
Logical Data Grouping
db2

 
Monitor Switch
Basic

Resettable

Yes

 

Element Name
Element Type

post_threshold_hash_joins
counter

Description:  The total number of times that a hash join heap request was limited due to concurrent use of shared or private sort heap space.

Usage:  If this value is large (greater than 5% of Hash Join Overflows), the sort heap threshold should be increased.