Long running queries status
This attribute determines the status of long running SQL queries in each DB2 database. It is configurable from TSPS in the KM Administration section by the provided threshold checkbox whose default the value is 60 sec, and the input min and max threshold range is 30 - 1800 sec.
The KM calculates the response time of any SQL query running to collect the KM data and discovers the KM components. If the SQL query response time exceeds the configured threshold (the default is 60 sec), the KM will set the value of LongRunningQueriesStatus to 1 (Not OK) and displays an annotation. After displaying the annotation, the KM will directly set the value to 0 (OK) and continue to display OK until the next long response SQL queries occur again.
Default parameter attributes
Attribute | Default value |
|---|---|
Application class | DB2_DATABASE |
Command type | Not applicable |
Platform | All |
Icon style | State Boolean |
Unit | 0 - OK |
Border range | Undefined |
Alarm1 range | Undefined |
Alarm2 range | Undefined |
Scheduling (poll time) | 1 minute |
Active at installation | Yes |
Parameter type | Consumer |
Value set by | availabilityCollector |
TrueSight/ BMC Helix Operations Management properties
Attribute | Default value |
|---|---|
Monitor type | DB2 Database |
Key Performance Indicator | No |
Monitor for abnormalities | No |
Graph by default | Yes |
Availability | No |
Response time | No |
Normal distribution | No |
Statistical | No |