2.4 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:

2.4.1 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 2-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:

  1. Normal

  2. Attention

  3. Warning

  4. Alarm

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:

  • 3001 — Tablespace Container State

  • 3002 — Tablespace Container Utilization

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.

2.4.2 Container Health

The metrics in this category return container information from a health snapshot of a database.

Default Collection Interval — Every 30 minutes

Table 2-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:

  • 1 — Normal

  • 2 — Attention

  • 3 — Warning

  • 4 — Alarm

Snapshot Timestamp

Time when the query was executed.

2.4.3 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 2-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.

2.4.4 Database Health

The metrics in this category return information from a health snapshot of a database.

Default Collection Interval — Every 30 minutes

Table 2-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:

  • 1 — Normal

  • 2 — Attention

  • 3 — Warning

  • 4 — Alarm

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.

2.4.5 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 2-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:

  • 1 — Normal

  • 2 — Attention

  • 3 — Warning

  • 4 — Alarm

A warning or alarm condition indicates that the Health Indicator Alert Type should be examined.

Health Indicator Alert Type

If alert_state_raw equals:

  • 3001 — Tablespace Container State

  • 3002 — Tablespace Container Utilization

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.

2.4.6 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 2-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:

  • 1 — Normal

  • 2 — Attention

  • 3 — Warning

  • 4 — Alarm

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.

2.4.7 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 2-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:

  • 1 — Normal

  • 2 — Attention

  • 3 — Warning

  • 4 — Alarm

A warning or alarm condition indicates there are one or more alerts on the database.

Health Indicator Alert Type

If alert_state_raw equals:

  • 3001 — Tablespace Container State

  • 3002 — Tablespace Container Utilization

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.

2.4.8 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 2-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:

  • 1 — Normal

  • 2 — Attention

  • 3 — Warning

  • 4 — Alarm

Snapshot Timestamp

Time when the query was executed.

2.4.9 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 2-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:

  • 1 — Normal

  • 2 — Attention

  • 3 — Warning

  • 4 — Alarm

Health Indicator Alert Type

If alert_state_raw equals:

  • 3001 — Tablespace Container State

  • 3002 — Tablespace Container Utilization

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.