In DB2 Version 10.1, HADR monitoring has been enhanced to
support multiple standby databases, as well as provide better performance
monitoring for single and multiple standby systems.
A new table function,
MON_GET_HADR has been added. "db2pd -hadr" output content and format
has been updated. The two interfaces return identical information. The table
function uses standard SQL interface, so it is very flexible. It can be queried
from any SQL client and the output can be further processed by SQL filter,
join, aggregate, etc. In comparison, db2pd can only be issued on the database
host machine. But db2pd is lightweight, works on reads on
standby disabled databases, and can be easily
incorporated into admin scripts.All old interfaces
such as CLP database snapshot command, SNAPHADR view, SNAP_GET_HADR table
function, snapshot monitor element API are deprecated for HADR monitoring.
Note: Unless reads on standby is enabled, the table function cannot be issued to a standby database.
Monitoring from the primary or using db2pd on the standby is recommended.