Post threshold sorts (PostThreshSorts)
This parameter indicates the number of sorts that have requested heaps after the sort heap threshold has been reached. This parameter can be used to tune the sheapthres and sortheap configuration parameters if this parameter value is excessive.
Alternatively, applications running against the database instance can be modified (using SQL query changes) so that fewer or smaller sorts are performed.
Default parameter attributes
Attribute | Default value |
|---|---|
Application class | DB2_INSTANCE_PARTITION_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 Partition Parameters |
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.