3.在host1上创建数据库: db2 "create db hadrdb automatic storage no"
4.设置主数据库配置参数: 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
查看hadr相关的配置参数 db2 get db cfg for hadrdb | grep -i hadr Database Configuration for Database hadrdb HADR database role = STANDARD HADR local host name (HADR_LOCAL_HOST) = HADR local service name (HADR_LOCAL_SVC) = HADR remote host name (HADR_REMOTE_HOST) = HADR remote service name (HADR_REMOTE_SVC) = HADR instance name of remote server (HADR_REMOTE_INST) = HADR timeout value (HADR_TIMEOUT) = 120 HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC HADR peer window duration (seconds) (HADR_PEER_WINDOW) = 0
把没有设置的部分填上:
db2 update db cfg for hadrdb using hadr_local_host rubbia; db2 update db cfg for hadrdb using hadr_local_svc 54321; db2 update db cfg for hadrdb using hadr_remote_host joule; db2 update db cfg for hadrdb using hadr_remote_svc 54321 hadr_remote_inst chenhui;
7.在host2上,修改数据库配置参数 /home/chenhui->db2 get db cfg for hadrdb | grep -i hadr Database Configuration for Database hadrdb HADR database role = STANDARD HADR local host name (HADR_LOCAL_HOST) = rubbia HADR local service name (HADR_LOCAL_SVC) = 54321 HADR remote host name (HADR_REMOTE_HOST) = joule HADR remote service name (HADR_REMOTE_SVC) = 54321 HADR instance name of remote server (HADR_REMOTE_INST) = chenhui HADR timeout value (HADR_TIMEOUT) = 120 HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC HADR peer window duration (seconds) (HADR_PEER_WINDOW) = 0
注意把 local host name 和remote host name互换, db2 update db cfg for hadrdb using HADR_LOCAL_HOST joule HADR_REMOTE_HOST rubbia
8.在host2上,启动db2为standby db2 start hadr on db hadrdb as standby 注意:这里要先启动standby
9.在host1上,启动db2为primary db2 start hadr on db hadrdb as primary
添加新评论12 条评论
2013-04-02 19:37
2013-01-25 11:07
2012-09-21 17:05
2012-09-17 17:17
2012-09-13 15:59
2012-09-13 01:06
2012-09-12 12:44
2012-09-11 22:05
2012-09-11 13:32
2012-09-11 09:35
2012-09-09 08:49
2012-08-24 12:06