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 |
Availability | No |
Response time | No |
Normal distribution | Yes |
Statistical | No |
Comments
Log in or register to comment.