The reason is prior to v10.1, HADR role is stored in database
configuration but in 10.1 code was changed to store information
in the global structure which was not copied to database
configuration file. Hence db2pd -dbcfg returned incorrect
result.
Primary:
[test@Testmachine]/nfshome/test>db2pd -db drdb -dbcfg |grep -E
"Description|role"
Description Memory Value Disk Value
HADR database role STANDARD STANDARD
[test@Testmachine]/nfshome/test>db2pd -db drdb -hadr
Database Member 0 -- Database DRDB -- Active -- Up 0 days
00:12:09 -- Date 2014-07-17-19.28.38.018023
HADR_ROLE = PRIMARY
REPLAY_TYPE = PHYSICAL
HADR_SYNCMODE = SYNC
STANDBY_ID = 1
LOG_STREAM_ID = 0
HADR_STATE = PEER
PRIMARY_MEMBER_HOST = Testmachine
PRIMARY_INSTANCE = test
PRIMARY_MEMBER = 0
STANDBY_MEMBER_HOST = gauss
STANDBY_INSTANCE = test
STANDBY_MEMBER = 0
HADR_CONNECT_STATUS = CONNECTED
HADR_CONNECT_STATUS_TIME = 07/17/2014
19:16:38.230848 (1405649798)
HEARTBEAT_INTERVAL(seconds) = 5
HADR_TIMEOUT(seconds) = 20
TIME_SINCE_LAST_RECV(seconds) = 5
PEER_WAIT_LIMIT(seconds) = 0
LOG_HADR_WAIT_CUR(seconds) = 0.000
LOG_HADR_WAIT_RECENT_AVG(seconds) = 0.000000
LOG_HADR_WAIT_ACCUMULATED(seconds) = 0.000
LOG_HADR_WAIT_COUNT = 0
SOCK_SEND_BUF_REQUESTED,ACTUAL(bytes) = 0, 16384
SOCK_RECV_BUF_REQUESTED,ACTUAL(bytes) = 0, 87380
PRIMARY_LOG_FILE,PAGE,POS = S0000000.LOG, 0,
40760046
STANDBY_LOG_FILE,PAGE,POS = S0000000.LOG, 0,
40760046
HADR_LOG_GAP(bytes) = 0
STANDBY_REPLAY_LOG_FILE,PAGE,POS = S0000000.LOG, 0,
40760046
STANDBY_RECV_REPLAY_GAP(bytes) = 0
PRIMARY_LOG_TIME = 07/01/2014
18:20:59.000000 (1404264059)
STANDBY_LOG_TIME = 07/01/2014
18:20:59.000000 (1404264059)
STANDBY_REPLAY_LOG_TIME = 07/01/2014
18:20:59.000000 (1404264059)
STANDBY_RECV_BUF_SIZE(pages) = 4300
STANDBY_RECV_BUF_PERCENT = 0
STANDBY_SPOOL_LIMIT(pages) = 0
PEER_WINDOW(seconds) = 30
PEER_WINDOW_END = 07/17/2014
19:29:03.000000 (1405650543)
READS_ON_STANDBY_ENABLED = N
[test@Testmachine]/nfshome/test>db2 connect to drdb
Database Connection Information
Database server = DB2/LINUXX8664 10.1.4
SQL authorization ID = test
Local database alias = DRDB
[test@Testmachine]/nfshome/test>db2 get db cfg for drdb show
detail|grep -E "Value|database role"
Description Parameter
Current Value Delayed Value
HADR database role =
PRIMARY PRIMARY
Standby:
[test@gauss]/nfshome/test>db2pd -db drdb -dbcfg |grep -E
"Description|role"
Description Memory Value Disk Value
HADR database role STANDARD STANDBY
[test@gauss]/nfshome/test>db2pd -db drdb -hadr
Database Member 0 -- Database DRDB -- Standby -- Up 0 days
00:21:24 -- Date 2014-07-17-19.36.47.318351
HADR_ROLE = STANDBY
REPLAY_TYPE = PHYSICAL
HADR_SYNCMODE = SYNC
STANDBY_ID = 0
LOG_STREAM_ID = 0
HADR_STATE = PEER
PRIMARY_MEMBER_HOST = Testmachine
PRIMARY_INSTANCE = test
PRIMARY_MEMBER = 0
STANDBY_MEMBER_HOST = gauss
STANDBY_INSTANCE = test
STANDBY_MEMBER = 0
HADR_CONNECT_STATUS = CONNECTED
HADR_CONNECT_STATUS_TIME = 07/17/2014
19:16:38.234573 (1405649798)
HEARTBEAT_INTERVAL(seconds) = 5
HADR_TIMEOUT(seconds) = 20
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.000000
LOG_HADR_WAIT_ACCUMULATED(seconds) = 0.000
LOG_HADR_WAIT_COUNT = 0
SOCK_SEND_BUF_REQUESTED,ACTUAL(bytes) = 0, 16384
SOCK_RECV_BUF_REQUESTED,ACTUAL(bytes) = 0, 87380
PRIMARY_LOG_FILE,PAGE,POS = S0000000.LOG, 0,
40760046
STANDBY_LOG_FILE,PAGE,POS = S0000000.LOG, 0,
40760046
HADR_LOG_GAP(bytes) = 0
STANDBY_REPLAY_LOG_FILE,PAGE,POS = S0000000.LOG, 0,
40760046
STANDBY_RECV_REPLAY_GAP(bytes) = 0
PRIMARY_LOG_TIME = 07/01/2014
18:20:59.000000 (1404264059)
STANDBY_LOG_TIME = 07/01/2014
18:20:59.000000 (1404264059)
STANDBY_REPLAY_LOG_TIME = 07/01/2014
18:20:59.000000 (1404264059)
STANDBY_RECV_BUF_SIZE(pages) = 4300
STANDBY_RECV_BUF_PERCENT = 0
STANDBY_SPOOL_LIMIT(pages) = 0
PEER_WINDOW(seconds) = 30
PEER_WINDOW_END = 07/17/2014
19:37:13.000000 (1405651033)
READS_ON_STANDBY_ENABLED = N
[test@gauss]/nfshome/test>db2 get db cfg for drdb |grep -i role
HADR database role =
STANDBY |
