HADR Step by Step Process in DB2 LUW
HADR Step by Step Process in DB2
Instances DB2 and DB2INST1
DBNAME : SAMPLE in both instances
We have to update following HADR Parameters
PRIMARY(DB2):
db2 UPDATE DB CFG FOR SAMPLE USING LOGINDEXBUILD ON
db2 UPDATE DB CFG FOR SAMPLE USING INDEXREC RESTART
db2 UPDATE DB CFG FOR SAMPLE USING HADR_LOCAL_HOST 192.168.1.10
db2 UPDATE DB CFG FOR SAMPLE USING HADR_LOCAL_SVC 52001
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_HOST 192.168.1.10
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_SVC 52002
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_INST DB2INST1
db2 UPDATE DB CFG FOR SAMPLE USING HADR_TIMEOUT 120
db2 UPDATE DB CFG FOR SAMPLE USING HADR_SYNCMODE SYNC
db2 UPDATE DB CFG FOR SAMPLE USING LOGARCHMETH1 LOGRETAIN
SECONDARY(DB2INST1):
db2 UPDATE DB CFG FOR SAMPLE USING LOGINDEXBUILD ON
db2 UPDATE DB CFG FOR SAMPLE USING INDEXREC RESTART
db2 UPDATE DB CFG FOR SAMPLE USING HADR_LOCAL_HOST 192.168.1.10
db2 UPDATE DB CFG FOR SAMPLE USING HADR_LOCAL_SVC 52002
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_HOST 192.168.1.10
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_SVC 52001
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_INST DB2
db2 UPDATE DB CFG FOR SAMPLE USING HADR_TIMEOUT 120
db2 UPDATE DB CFG FOR SAMPLE USING HADR_SYNCMODE SYNC
db2 UPDATE DB CFG FOR SAMPLE USING LOGARCHMETH1 LOGRETAIN
Next stop both instances and start those again.
FIRST HAVE TO START STANDBY
db2 start hadr on database sample as standby
NEXT HAVE TO START PRIMARY
db2 start hadr on database sample as primary
WE CAN CHECK DATABASE STATS USING
db2pd -db sample -hadr