DB2 HADR

Primary server:  ha01(192.168.101.23)
Standby server:  ha02(192.168.101.24)
db2 instance name : inst97
db2 level:DB2 v9.7.0.3
db name: hadrdb

 

step 1:create db hadrdb on Primary and Standby

1, login ha01 as inst97
mkdir -p /db2data/hadrdb
db2 create database hadrdb on  '/db2data/hadrdb'

2,login ha02 as inst97
mkdir -p /db2data/hadrdb
db2 create database hadrdb on  '/db2data/hadrdb'

 

step 2:Configuring HADR Primary

1, login ha01 as inst97
db2 update db cfg for hadrdb using logretain on
db2 update db cfg for hadrdb using trackmod on
db2 update db cfg for hadrdb using logindexbuild on
db2 update db cfg for hadrdb using indexrec restart

db2 get db cfg for hadrdb | grep -i hadr
db2 update db cfg for hadrdb using hadr_local_host ha01;
db2 update db cfg for hadrdb using hadr_local_svc DB2_inst97;
db2 update db cfg for hadrdb using hadr_remote_host ha02;
db2 update db cfg for hadrdb using hadr_remote_svc DB2_inst97 hadr_remote_inst inst97;

step 3:backup Primary database
1, login ha01 as inst97
db2 "backup database hadrdb to /db2data/hadrdb compress"

2,copy backup files to ha02,using the second backup
scp HADRDB.0.inst97.NODE0000.CATN0000.20150204151636.001 inst97@ha02:/db2data/hadrdb

step 4:restore backup database
1, login ha02 as inst97
db2 "restore database hadrdb  from /db2data/hadrdb taken at 20150204151636"

step 5:Configuring HADR Standby
db2 get db cfg for hadrdb | grep -i hadr
db2 update db cfg for hadrdb using HADR_LOCAL_HOST ha02 HADR_REMOTE_HOST ha01

step 6, start hadr
1, login ha02 as inst97
db2 start hadr on db hadrdb as standby

2, login ha01 as inst97
db2 start hadr on db hadrdb as primary

step 7, check hadr
db2pd -db hadrdb -hadr