Number of hash join small overflows (HashJoinSmallOverflows)

This parameter indicates the number of times that the hash join data exceeded the available sort heap space by less than 10 percent.

Default parameter attributes

Attribute
Default value

Application class

DB2DB_PERFORMANCE

Command type

Not applicable

Platform

All

Icon style

Graph

Unit

Number (#)

Border range

Undefined

Alarm1 range

Undefined

Alarm2 range

Undefined

Scheduling (poll time)

Inherited

Active at installation

No

Parameter type

Consumer

Value set by

dataCollector

TrueSight/ BMC Helix Operations Management properties

Attribute

Default value

Monitor type

DB2 Database Performance

Key Performance Indicator

No
Monitor for abnormalities
Yes
Graph by default
Yes
AvailabilityNo
Response time
No
Normal distribution
Yes
StatisticalNo
Was this page helpful? Yes No Submitting... Thank you

Comments