DB2 HADR Basic

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


            
            
请使用浏览器的分享功能分享到微信等