Health Indicators/Alarms
Health Indicators/Alarms metrics return the health information and current values for all the snapshot levels of containers, tablespaces, databases and the Database Manager. Health Indicators/Alarms metrics consist of the following categories:
Container Health Indicator
The metrics in this category return health indicator information for tablespace containers from a health snapshot of tablespaces in a database.
Default Collection Interval — Every 30 minutes
Table 3-8 Container Health Indicator Metrics
Metric | Description and User Action |
---|---|
Container Health Indicator Additional Info |
Additional information present in the Container Health Indicator metrics. |
Container Health Indicator Alert State |
State of the alert. If alert_state_raw equals:
A warning or alarm condition indicates that you should examine the Health Indicator Alert Type. |
Container Name |
Name of the container. |
Health Indicator Alert Type |
Type of alert. If alert_state_raw equals:
|
Health Indicator Identifier |
Identifier for the alert. |
Health Indicator Timestamp |
Time when the alert was generated. |
Health Indicator Value |
Value for the alert. |
Node Number |
Node at which the alert was generated. |
Snapshot Timestamp |
Time when the query was executed. |
Container Health
The metrics in this category return container information from a health snapshot of a database.
Default Collection Interval — Every 30 minutes
Table 3-9 Container Health Metrics
Metric | Description and User Action |
---|---|
Container Name (key column) |
Name of the container. |
Tablespace Name (key column) |
Name of the tablespace to which the container belongs. |
Node Number |
Node at which the container resides. |
Container Rolled Up Alert State |
If alert_state_raw equals:
|
Snapshot Timestamp |
Time when the query was executed. |
Database Collection Health Indicator
The metrics in this category return container information from a health snapshot of a database.
Default Collection Interval — Every 30 minutes
Table 3-10 Database Collection Health Indicator Metrics
Metric | Description and User Action |
---|---|
Health Indicator Object Detail |
Description of the object. |
Health Indicator Object Name |
Name of the object. |
Health Indicator Object State |
Severity of the alert. |
Health Indicator Object State Detail |
Type of alert state. A warning or alarm condition indicates that the Health Indicator Alert Type should be examined. |
Database Health
The metrics in this category return information from a health snapshot of a database.
Default Collection Interval — Every 30 minutes
Table 3-11 Database Health Metrics
Metric | Description and User Action |
---|---|
Database Name (key column) |
Name of the database. |
Database Path |
Physical path of the database. |
Logical Location of Database |
Location of the database with respect to the DBM. |
Database Rolled Up Alert State |
If alert_state_raw equals:
A warning or alarm condition indicates there are one or more alerts on the database. |
Database Alias |
Alias name for the database. |
Server Platform |
Platform where the database is installed. |
Snapshot Timestamp |
Time when the query was executed. |
Database Health Indicator
The metrics in this category return health indicator information from a health snapshot of a database.
Default Collection Interval — Every 30 minutes
Table 3-12 Database Health Indicator Metrics
Metric | Description and User Action |
---|---|
Health Indicator Identifier |
Unique identifier for Health Indicator. |
Database Health Indicator Alert State |
If alert_state_raw equals:
A warning or alarm condition indicates that the Health Indicator Alert Type should be examined. |
Health Indicator Alert Type |
If alert_state_raw equals:
|
Health Indicator Timestamp |
Time when the alert was generated. |
Health Indicator Value |
Value for the alert. |
Snapshot Timestamp |
Time when the query was executed. |
Database Health Indicator Additional Info |
Additional information present in the Database Health Indicator metrics. |
Database Manager Health
The metrics in this category return information from a health snapshot of the DB2 Database Manager.
Default Collection Interval — Every 30 minutes
Table 3-13 Database Manager Health Metrics
Metric | Description and User Action |
---|---|
Server Instance Name (key column) |
Host name where DB2 is installed. |
DB2 Startup Time |
Time DB2 was last started. |
Last Reset |
Time DB2 was last reset. |
Number of Nodes in DB2 Instance |
Number of nodes in the DB2 instance. |
Rolled up Alert State |
If alert_state_raw equals:
A warning or alarm condition indicates that the Health Indicator Alert Type should be examined. |
Server Instance Name |
Host name where DB2 is installed |
Snapshot Timestamp |
Time when the query was executed. |
Database Manager Health Indicator
The metrics in this category return health indicator information from a health snapshot of the DB2 Database Manager.
Default Collection Interval — Every 30 minutes
Table 3-14 Database Manager Health Indicator Metrics
Metric | Description and User Action |
---|---|
Database Name (key column) |
Name of the database. |
DB Manager Health Indicator Additional Info |
Additional information present in the DBM Health Indicator metrics. |
DB Manager Health Indicator Alert State |
If alert_state_raw equals:
A warning or alarm condition indicates there are one or more alerts on the database. |
Health Indicator Alert Type |
If alert_state_raw equals:
|
Health Indicator Identifier |
Identifier for the alert. |
Health Indicator Timestamp |
Time when the alert was generated. |
Health Indicator Value |
Value for the alert. |
Server Instance Name |
Host name where DB2 is installed. |
Snapshot Timestamp |
Time when the query was executed. |
Additional Information |
Additional information present in the DBM Health Indicator metrics. |
Tablespaces Health
The metrics in this category return health indicator information for tablespaces from a health snapshot of tablespaces in a database.
Default Collection Interval — Every 30 minutes
Table 3-15 Tablespaces Health Metrics
Metric | Description and User Action |
---|---|
Tablespace Name (key column) |
Name of the tablespace. |
Tablespace Rolled Up Alert State |
If alert_state_raw equals:
|
Snapshot Timestamp |
Time when the query was executed. |
Tablespace Health Indicator
The metrics in this category return health indicator information for tablespaces from a health snapshot of tablespaces in a database.
Default Collection Interval — Every 30 minutes
Table 3-16 Tablespace Health Indicator Metrics
Metric | Description and User Action |
---|---|
Tablespace Name (key column) |
Name of the tablespace. |
Tablespace Health Indicator Alert State |
If alert_state_raw equals:
|
Health Indicator Alert Type |
If alert_state_raw equals:
|
Health Indicator Identifier |
Identifier for the alert. |
Health Indicator Timestamp |
Time when the alert was generated. |
Health Indicator Value |
Value for the alert. |
Snapshot Timestamp |
Time when the query was executed. |
Tablespace Health Indicator Additional Info |
Additional information present in the Tablespace Health Indicator metrics. |