High availability disaster recovery (HADR) health indicators

db.hadr_op_status - HADR Operational Status health indicator

This health indicator tracks the high availability disaster recovery (HADR) operational state of the database. The state between primary and standby servers can be one of the following values: Connected, Congested or Disconnected. A change from Connected to another state might generate an Attention alert.

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
db.hadr_op_status
Health monitor level
Database
Category
High availability disaster recovery
Type
State-based
Unit
Not applicable

db.hadr_delay - HADR Log Delay health indicator

This health indicator tracks the current average delay (in minutes) between the data changes on the primary database and the replication of those changes on the standby database.

With a large delay value, data loss can occur when failing over to the standby database after a failure on the primary database. A large delay value can also mean longer downtime when takeover is required, because the primary database is ahead of the standby database.
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
db.hadr_delay
Health monitor level
Database
Category
High availability disaster recovery
Type
Upper-bounded threshold-based
Unit
Minutes