Database manager (DBMS) health indicators

db2.db2_op_status - Instance Operational State health indicator

An instance is considered healthy if the instance state does not restrict activity or tasks being performed.

Important: The health monitor, health indicators, and related components have been deprecated in Version 9.7 and might be removed in a future release. Health monitor is not supported in DB2® pureScale® environments. For more information, see Health monitor has been deprecated.
Identifier
db2.db2_op_status
Health monitor level
Instance
Category
DBMS
Type
State-based
Unit
Not applicable

The state can be one of the following values: Active, Quiesce pending, Quiesced, or Down. A non-Active state may generate an Attention alert.

The health monitor is unable to execute actions for the db2.db2_op_status health indicator if the indicator enters the down state. This state can arise, for example, when an instance that the indicator is monitoring becomes inactive because of an explicit stop request or an abnormal termination. If you want to have the instance restart automatically after any abnormal termination, you can configure the fault monitor (db2fm) to keep the instance highly available.

Instance Highest Severity Alert State health indicator

This indicator represents the rolled-up alert state of an instance being monitored. The alert state of an instance is the highest alert state of the instance and its databases, and database objects being monitored.

Important: The health monitor, health indicators, and related components have been deprecated in Version 9.7 and might be removed in a future release. Health monitor is not supported in DB2 pureScale environments. For more information, see Health monitor has been deprecated.
Identifier
Not applicable. This health indicator does not have configuration or recommendations support.
Health monitor level
Instance
Category
DBMS
Type
State-based
Unit
Not applicable
The order of the alert states is as follows:
  • Alarm
  • Warning
  • Attention
  • Normal

The alert state of the instance determines the overall health of the DB2 database system.