Percentage of overflow sort requests (PctOverflowSortReqs)

This parameter indicates the percentage of the sorts for the selected database that did not have enough sort heap allocated and that required temporary disk space for storage purposes. This parameter may be used to determine the proper setting for the sortheap configuration parameter.

Recommendation:

If this parameter value is too high, increasing the sortheap value should reduce the number of overflowed sort requests.

 Default parameter attributes

Attribute
Default value

Application class

DB2DB_PERFORMANCE

Command type

Not applicable

Platform

All

Icon style

Graph

Unit

Percent

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