SQL query status (SQLQueryStatus)
This parameter indicates the status of the SQL query. By default, the parameter polling time is 1 min. It sets value to 1 (Not OK) if an error occur in any SQL query that KM uses to collect data or discover components and displays an annotation.
After displaying the annotation, the KM will directly set the value to 0 (OK) and will continue to display 0(OK) until new query fails.
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 |