搞了好几天总算是把HADR弄好啦，下面分享下
系统环境：
DB: db29.7.0.5
DB2server1:192.168.5.151 db2inst1
DB2server2:192.168.5.152 db2inst2
步骤：
DB2server1上操作：
db2inst1@DB2server1:~> db2 create database oga;
db2inst1@DB2server1:~> db2 get dbm cfg | grep SVC
db2inst1@DB2server1:~> db2set db2comm=tcpip
db2inst1@DB2server1:~> db2 update dbm cfg usingSVCENAME 50001
db2inst1@DB2server1:~> db2 update db cfg for ogausing logretain on
db2inst1@DB2server1:~> db2 update db cfg for ogausing trackmod on;
db2inst1@DB2server1:~> db2 update db cfg for ogausing logindexbuild on;
db2inst2@DB2server1:~> db2 backup db oga
db2inst1@DB2server1:~> db2 "create tablecert(OrgID int not null,EntId int not null,certnum char(20) not null primarykey,issuedate date)"
db2inst1@DB2server1:~> db2 "alter table certdata capture changes"
db2inst1@DB2server1:~> db2 "create tableorg(OrgId int not null primary key, OrgName char(20)) date capturechanges"
db2inst1@DB2server1:~> db2 "insert into orgvalues(1, 'org1')"
db2inst1@DB2server1:~> db2 "insert into orgvalues(2, 'org2')"
db2inst1@DB2server1:~> db2 "insert into orgvalues(3, 'org3')"
db2inst1@DB2server1:~> db2 "insert into certvalues(1, 2, 'cert1','2009-12-5')"
db2inst1@DB2server1:~> db2 "insert into certvalues(2, 2, 'cert2','2010-3-5')"
db2inst1@DB2server1:~> db2 "insert into certvalues(3, 2, 'cert3', current date)"
db2inst1@DB2server1:~> db2 update db cfg for ogausing hadr_local_svc 44455
DB20000I TheUPDATE DATABASE CONFIGURATION command completed successfully.
db2inst1@DB2server1:~> db2 update db cfg for ogausing hadr_remote_host 192.168.5.152
DB20000I TheUPDATE DATABASE CONFIGURATION command completed successfully.
db2inst1@DB2server1:~> db2 update db cfg for ogausing hadr_local_host 192.168.5.151
DB20000I TheUPDATE DATABASE CONFIGURATION command completed successfully.
db2inst1@DB2server1:~> db2 update db cfg for ogausing hadr_remote_svc 33344
DB20000I TheUPDATE DATABASE CONFIGURATION command completed successfully.
db2inst1@DB2server1:~> db2 update db cfg for ogausing hadr_remote_inst db2inst2
DB20000I TheUPDATE DATABASE CONFIGURATION command completed successfully.
db2inst1@DB2server1:~> db2 update db cfg for ogausing hadr_syncmode nearsync
DB20000I TheUPDATE DATABASE CONFIGURATION command completed successfully.
db2 UPDATE ALTERNATE SERVER FOR DATABASE SAMPLE USINGHOSTNAME 192.168.5.151 PORT 50001
db2inst1@DB2server1:~> db2 get db cfg for oga | grep-i hadr
DB2server2上的操作
db2inst1@DB2server2:~> db2 create database oga;
db2inst1@DB2server2:~> db2 get dbm cfg | grep SVC
db2inst1@DB2server2:~> db2set db2comm=tcpip
db2inst1@DB2server2:~> db2 update dbm cfg usingSVCENAME 50001
db2inst1@DB2server2:~> db2 update db cfg for ogausing logretain on
db2inst1@DB2server2:~> db2 update db cfg for ogausing trackmod on;
db2inst1@DB2server2:~> db2 update db cfg for ogausing logindexbuild on;
db2inst1@DB2server1:/opt/bak> db2 backup db oga to/opt/bak
db2inst1@DB2server2:~> db2 "create tablecert(OrgID int not null,EntId int not null,certnum char(20) not null primarykey,issuedate date)"
db2inst1@DB2server2:~> db2 "alter table certdata capture changes"
db2inst1@DB2server2:~> db2 "create tableorg(OrgId int not null primary key, OrgName char(20)) date capturechanges"
db2inst2@DB2server2:~> db2 update db cfg for ogausing hadr_local_host 192.168.5.152
DB20000I TheUPDATE DATABASE CONFIGURATION command completed successfully.
d