Average wait time for lock (AveWaitForLock)
This parameter indicates the average amount of time (in milliseconds) any application running against the database spent waiting before a lock request was granted. This information can be used to tune the locktimeout, locklist, and/or maxlocks configuration parameters.
Default parameter attributes
Attribute | Default value |
---|---|
Application class | DB2DB_LOCK |
Command type | Not applicable |
Platform | All |
Icon style | Graph |
Unit | Ms |
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 Lock |
Key Performance Indicator | No |
Monitor for abnormalities | Yes |
Graph by default | Yes |
Availability | No |
Response time | No |
Normal distribution | Yes |
Statistical | No |
Was this page helpful? Yes No
Submitting...
Thank you
Comments
Log in or register to comment.