DB2对于Linux下HADR配置步骤
1、首先修改主数据库参数:
db2 UPDATE DB CFG FOR SAMPLE USING LOGRETAIN ON
db2 UPDATE DB CFG FOR SAMPLE USING TRACKMOD ON
db2 UPDATE DB CFG FOR SAMPLE USING LOGINDEXBUILD ON
db2 UPDATE DB CFG FOR SAMPLE USING INDEXREC RESTART
2、备份主数据库:
db2 backup db sample to /home/db2inst1/db2backup/
3、在备机上恢复主数据库的备份:
db2 RESTORE DATABASE SAMPLE FROM /home/db2inst1/db2backup/ TAKEN AT 20120318170108 REPLACE HISTORY FILE WITHOUT PROMPTING
4、配置主数据库HADR参数:
db2 UPDATE DB CFG FOR SAMPLE USING HADR_LOCAL_HOST 10.10.10.10(主)
db2 UPDATE DB CFG FOR SAMPLE USING HADR_LOCAL_SVC DB2_HADR_1
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_HOST 10.10.10.11(备)
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_SVC DB2_HADR_2
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_INST db2inst1
db2 UPDATE DB CFG FOR SAMPLE USING HADR_SYNCMODE NEARSYNC
db2 UPDATE DB CFG FOR SAMPLE USING HADR_TIMEOUT 120
5、配置备数据库HADR参数:
db2 UPDATE DB CFG FOR SAMPLE USING HADR_LOCAL_HOST 10.10.10.11(备)
db2 UPDATE DB CFG FOR SAMPLE USING HADR_LOCAL_SVC DB2_HADR_2
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_HOST 10.10.10.10(主)
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_SVC DB2_HADR_1
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_INST db2inst1
db2 UPDATE DB CFG FOR SAMPLE USING HADR_SYNCMODE NEARSYNC
db2 UPDATE DB CFG FOR SAMPLE USING HADR_TIMEOUT 120
6、激活数据库、启动HADR:(首先备机启动,然后主机启动)
db2 activate db sample
db2 DEACTIVATE DATABASE SAMPLE
db2 START HADR ON DATABASE SAMPLE AS STANDBY
db2 DEACTIVATE DATABASE SAMPLE
db2 START HADR ON DATABASE SAMPLE AS PRIMARY
7、插入相关表做测试:
db2 "create table test (id int)"
db2 "insert into test values (1)"
db2 "insert into test values (2)"
db2 "insert into test values (3)"
8、切换主备数据库角色:
TAKEOVER HADR ON DATABASE SAMPLE USER db2inst1 USING db2inst1
db2 TAKEOVER HADR ON DATABASE SAMPLE user db2inst1 using db2inst1 by force
备注:若主数据库的HADR无法启动,尝试修改防火墙设置:(关闭防护墙)
linux防火墙设置
1) 重启后生效
开启: chkconfig iptables on
关闭: chkconfig iptables off
2) 即时生效,重启后失效
开启: service iptables start
关闭: service iptables stop
1、首先修改主数据库参数:
db2 UPDATE DB CFG FOR SAMPLE USING LOGRETAIN ON
db2 UPDATE DB CFG FOR SAMPLE USING TRACKMOD ON
db2 UPDATE DB CFG FOR SAMPLE USING LOGINDEXBUILD ON
db2 UPDATE DB CFG FOR SAMPLE USING INDEXREC RESTART
2、备份主数据库:
db2 backup db sample to /home/db2inst1/db2backup/
3、在备机上恢复主数据库的备份:
db2 RESTORE DATABASE SAMPLE FROM /home/db2inst1/db2backup/ TAKEN AT 20120318170108 REPLACE HISTORY FILE WITHOUT PROMPTING
4、配置主数据库HADR参数:
db2 UPDATE DB CFG FOR SAMPLE USING HADR_LOCAL_HOST 10.10.10.10(主)
db2 UPDATE DB CFG FOR SAMPLE USING HADR_LOCAL_SVC DB2_HADR_1
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_HOST 10.10.10.11(备)
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_SVC DB2_HADR_2
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_INST db2inst1
db2 UPDATE DB CFG FOR SAMPLE USING HADR_SYNCMODE NEARSYNC
db2 UPDATE DB CFG FOR SAMPLE USING HADR_TIMEOUT 120
5、配置备数据库HADR参数:
db2 UPDATE DB CFG FOR SAMPLE USING HADR_LOCAL_HOST 10.10.10.11(备)
db2 UPDATE DB CFG FOR SAMPLE USING HADR_LOCAL_SVC DB2_HADR_2
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_HOST 10.10.10.10(主)
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_SVC DB2_HADR_1
db2 UPDATE DB CFG FOR SAMPLE USING HADR_REMOTE_INST db2inst1
db2 UPDATE DB CFG FOR SAMPLE USING HADR_SYNCMODE NEARSYNC
db2 UPDATE DB CFG FOR SAMPLE USING HADR_TIMEOUT 120
6、激活数据库、启动HADR:(首先备机启动,然后主机启动)
db2 activate db sample
db2 DEACTIVATE DATABASE SAMPLE
db2 START HADR ON DATABASE SAMPLE AS STANDBY
db2 DEACTIVATE DATABASE SAMPLE
db2 START HADR ON DATABASE SAMPLE AS PRIMARY
7、插入相关表做测试:
db2 "create table test (id int)"
db2 "insert into test values (1)"
db2 "insert into test values (2)"
db2 "insert into test values (3)"
8、切换主备数据库角色:
TAKEOVER HADR ON DATABASE SAMPLE USER db2inst1 USING db2inst1
db2 TAKEOVER HADR ON DATABASE SAMPLE user db2inst1 using db2inst1 by force
备注:若主数据库的HADR无法启动,尝试修改防火墙设置:(关闭防护墙)
linux防火墙设置
1) 重启后生效
开启: chkconfig iptables on
关闭: chkconfig iptables off
2) 即时生效,重启后失效
开启: service iptables start
关闭: service iptables stop