Hash joins after heap threshold exceeded (PostThreshHashJoins)

This parameter indicates the total number of times that a hash join heap request was limited due to concurrent use of shared or private sort heap space.

Default parameter attributes

Attribute
Default value

Application class

DB2_INSTANCE_PARAMETERS

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 Instance Parameters

Key Performance Indicator

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

Comments