DB2: check if database is in HADR



$ db2pd -db wctst3 -hadr

Database Member 0 -- Database WCTST3 -- Active -- Up 1 days 23:04:33 -- Date 2025-03-10-09.03.46.609802

HADR Information:
HADR is not active.


OR


$ db2pd -db wctst10 -hadr

Database Member 0 -- Database WCTST10 -- Standby -- Up 0 days 11:35:12 -- Date 2025-03-21-08.53.34.211061

                            HADR_ROLE = STANDBY
                          REPLAY_TYPE = PHYSICAL
                        HADR_SYNCMODE = NEARSYNC
                           STANDBY_ID = 0
                        LOG_STREAM_ID = 0
                           HADR_STATE = PEER
                           HADR_FLAGS = TCP_PROTOCOL
                  PRIMARY_MEMBER_HOST = db2tst602
                     PRIMARY_INSTANCE = tst4ins4
                       PRIMARY_MEMBER = 0
                  STANDBY_MEMBER_HOST = db2tst601
                     STANDBY_INSTANCE = tst3ins3
                       STANDBY_MEMBER = 0
                  HADR_CONNECT_STATUS = CONNECTED
             HADR_CONNECT_STATUS_TIME = 03/20/2025 21:36:09.264054 (1742524569)
          HEARTBEAT_INTERVAL(seconds) = 5
                     HEARTBEAT_MISSED = 0
                   HEARTBEAT_EXPECTED = 8129
                HADR_TIMEOUT(seconds) = 30
        TIME_SINCE_LAST_RECV(seconds) = 4
             PEER_WAIT_LIMIT(seconds) = 0
           LOG_HADR_WAIT_CUR(seconds) = 0.000
    LOG_HADR_WAIT_RECENT_AVG(seconds) = 0.001664
   LOG_HADR_WAIT_ACCUMULATED(seconds) = 23.923
                  LOG_HADR_WAIT_COUNT = 131886
SOCK_SEND_BUF_REQUESTED,ACTUAL(bytes) = 0, 46080
SOCK_RECV_BUF_REQUESTED,ACTUAL(bytes) = 0, 360960
            PRIMARY_LOG_FILE,PAGE,POS = S0092239.LOG, 1112, 20678192562650
            STANDBY_LOG_FILE,PAGE,POS = S0092239.LOG, 1112, 20678192562650
                  HADR_LOG_GAP(bytes) = 0
     STANDBY_REPLAY_LOG_FILE,PAGE,POS = S0092239.LOG, 1112, 20678192562650
       STANDBY_RECV_REPLAY_GAP(bytes) = 107
                     PRIMARY_LOG_TIME = 03/21/2025 08:53:30.000000 (1742565210)
                     STANDBY_LOG_TIME = 03/21/2025 08:53:30.000000 (1742565210)
              STANDBY_REPLAY_LOG_TIME = 03/21/2025 08:53:30.000000 (1742565210)
         STANDBY_RECV_BUF_SIZE(pages) = 4302
             STANDBY_RECV_BUF_PERCENT = 0
           STANDBY_SPOOL_LIMIT(pages) = 12375000
                STANDBY_SPOOL_PERCENT = 0
                   STANDBY_ERROR_TIME = NULL
                 PEER_WINDOW(seconds) = 300
                      PEER_WINDOW_END = 03/21/2025 08:58:30.000000 (1742565510)
             READS_ON_STANDBY_ENABLED = N
              HADR_LAST_TAKEOVER_TIME = NULL







OR



[tst4ins4@db2tst602  ~]
$ db2pd -db wctst10 -hadr

Database Member 0 -- Database WCTST10 -- Active -- Up 0 days 11:46:18 -- Date 2025-03-21-08.54.36.229880

                            HADR_ROLE = PRIMARY
                          REPLAY_TYPE = PHYSICAL
                        HADR_SYNCMODE = NEARSYNC
                           STANDBY_ID = 1
                        LOG_STREAM_ID = 0
                           HADR_STATE = PEER
                           HADR_FLAGS = TCP_PROTOCOL
                  PRIMARY_MEMBER_HOST = db2tst602
                     PRIMARY_INSTANCE = tst4ins4
                       PRIMARY_MEMBER = 0
                  STANDBY_MEMBER_HOST = db2tst601
                     STANDBY_INSTANCE = tst3ins3
                       STANDBY_MEMBER = 0
                  HADR_CONNECT_STATUS = CONNECTED
             HADR_CONNECT_STATUS_TIME = 03/20/2025 21:36:09.263554 (1742524569)
          HEARTBEAT_INTERVAL(seconds) = 5
                     HEARTBEAT_MISSED = 0
                   HEARTBEAT_EXPECTED = 8902
                HADR_TIMEOUT(seconds) = 30
        TIME_SINCE_LAST_RECV(seconds) = 2
             PEER_WAIT_LIMIT(seconds) = 0
           LOG_HADR_WAIT_CUR(seconds) = 0.000
    LOG_HADR_WAIT_RECENT_AVG(seconds) = 0.001604
   LOG_HADR_WAIT_ACCUMULATED(seconds) = 23.923
                  LOG_HADR_WAIT_COUNT = 131890
SOCK_SEND_BUF_REQUESTED,ACTUAL(bytes) = 0, 46080
SOCK_RECV_BUF_REQUESTED,ACTUAL(bytes) = 0, 362880
            PRIMARY_LOG_FILE,PAGE,POS = S0092239.LOG, 1112, 20678192565638
            STANDBY_LOG_FILE,PAGE,POS = S0092239.LOG, 1112, 20678192565638
                  HADR_LOG_GAP(bytes) = 0
     STANDBY_REPLAY_LOG_FILE,PAGE,POS = S0092239.LOG, 1112, 20678192565638
       STANDBY_RECV_REPLAY_GAP(bytes) = 0
                     PRIMARY_LOG_TIME = 03/21/2025 08:54:30.000000 (1742565270)
                     STANDBY_LOG_TIME = 03/21/2025 08:54:30.000000 (1742565270)
              STANDBY_REPLAY_LOG_TIME = 03/21/2025 08:54:30.000000 (1742565270)
         STANDBY_RECV_BUF_SIZE(pages) = 4302
             STANDBY_RECV_BUF_PERCENT = 0
           STANDBY_SPOOL_LIMIT(pages) = 12375000
                STANDBY_SPOOL_PERCENT = 0
                   STANDBY_ERROR_TIME = NULL
                 PEER_WINDOW(seconds) = 300
                      PEER_WINDOW_END = 03/21/2025 08:59:35.000000 (1742565575)
             READS_ON_STANDBY_ENABLED = N
              HADR_LAST_TAKEOVER_TIME = NULL









Comments

Post a Comment

Popular posts from this blog

Oracle: To clean up WRI$_ADV_OBJECTS

 set linesize 200; select segment_name, segment_type, bytes from dba_segments where tablespace_name='SYSAUX' order by bytes asc; COL OCCUPANT_NAME FORMAT A30 SELECT OCCUPANT_NAME,SPACE_USAGE_KBYTES FROM V$SYSAUX_OCCUPANTS ORDER BY SPACE_USAGE_KBYTES DESC; COL SEGMENT_NAME FORMAT A30 COL OWNER FORMAT A10 COL TABLESPACE_NAME FORMAT A10 COL SEGMENT_TYPE FORMAT A15 SELECT * FROM (SELECT SEGMENT_NAME,OWNER,TABLESPACE_NAME,BYTES/1024/1024 "SIZE(MB)",SEGMENT_TYPE FROM DBA_SEGMENTS WHERE TABLESPACE_NAME='SYSAUX' ORDER BY BYTES DESC) WHERE ROWNUM<=10; 1.  automatic clean-up default 31 days           SELECT dbms_stats.get_stats_history_availability from Dual; 2. modify retention policy        exec  dbms_stats.alter_stats_history_retention (14); 3. a manual cleaning  exec dbms_stats.purge_stats (sysdate-14);   ALTER TABLE WRI$_ADV_OBJECTS MOVE; ALTER INDEX WRI$_ADV_OBJECTS_IDX_01 REBUILD; ALTER INDEX WRI$_ADV_OBJECTS_IDX_02 R...
Read more