DB2 9 for z/OS DBA certification test ( Exam 732 )
"DB2 9 for z/OS Database Administration Certification Study Guide"
"DB2 9 for z/OS Database Administration Certification Study Guide"
HADR Status에 대한 관리 목적의 Catalog Table을 만들어두면 더 좋을 듯.
INSERT INTO DBA.HADR
SELECT
D.SNAPSHOT_TIMESTAMP, HADR_STATE, HADR_CONNECT_STATUS,
HADR_PRIMARY_LOG_PAGE, HADR_PRIMARY_LOG_LSN,
HADR_STANDBY_LOG_PAGE, HADR_STANDBY_LOG_LSN,
HADR_LOG_GAP,
APPLS_CUR_CONS
FROM
SYSIBMADM.SNAPDB D, SYSIBMADM.SNAPHADR H