HADR Configuration parameters
logindexbuild -> ON
logarchmeth1 -> DISK:/db1/achlog
indexrec -> RESTART
hadr_local_host
hadr_remote_host
hadr_local_svc
hadr_remote_svc
hadr_remote_inst
hadr_timeout
hadr_syncmode -> {SYNC,NEARSYNC,ASYNC,SUPERASYNC}
SYNC 主日志写完,从日志写完
NEARSYNC 主日志写完,从内存写完
ASYNC 主日志写完,发送到从,不会等待Acknowlwedgement
ASYNC 主日志写完
MON_GET_HADR
db2pd -hadr_local_host
Look for:
HADR_STATE = PEER
HADR_CONNECT_STATUS = CONNECTED
HADR_CONNECT_STATUS_TIME = 11/18/2017 08:30:48.121742 (1510993848)
HEARTBEAT_INTERVAL(seconds) = 30
TIME_SINCE_LAST_RECV(seconds) = 1
HADR_LOG_GAP(bytes) = 7942 (LSN gap between primary and standby)
STANDBY_RECV_REPLAY_GAP(bytes) = 1804