Use the new information to improve HADR monitoring. Several
new columns were added to the MON_GET_HADR table function and the
information returned by the -hadr parameter of the db2pd command.
You can use the following new columns to monitor the health of
your HADR databases:
- STANDBY_SPOOL_PERCENT lets you know how much of your HADR log
spooling space is being used.
- HADR_FLAGS contains a subset of fields that indicate when assisted
remote catchup is occurring or if there are issues with log receipt
or retrieval on the standby.
Starting in
DB2® Cancun
Release 10.5.0.4,
to enhance your ability to determine whether there are errors or communication
problems affecting your HADR deployment, the following columns were
also added to the MON_GET_HADR table function and the information
returned by the
db2pd command:
- HEARTBEAT_MISSED and HEARTBEAT_EXPECTED allow you to determine
whether the accumulated number of missed heartbeats is a cause for
concern.
- STANDBY_ERROR_TIME indicates the last time the standby had a major
error.