|
DB2 V8.2 HADR For AIX5.3 db2set DB2_HASH_JOIN=Y db2set DB2_RR_TO_RS=YES db2set DB2COMM=tcpip db2set DB2_PARALLEL_IO=* db2 update dbm cfg using svcename db2c_db2inst1 db2sampl 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 db2 backup database sample db2 restore database sample taken at 20060119154140 replace history file without prompting 配置自動(dòng)客戶端重新路由 在主服務(wù)器上運(yùn)行 db2 update alternate server for database sample using hostname 10.1.1.22 port 30000 在從服務(wù)器上運(yùn)行 db2 update alternate server for database sample using hostname 10.1.1.21 port 30000 兩臺(tái)機(jī)器都修改 vi /etc/services db2c_db2inst1 30000/tcp DB2_HADR_1 35001/tcp DB2_HADR_2 35002/tcp 修改主服務(wù)器參數(shù)： db2 update db cfg for sample using HADR_LOCAL_HOST 10.1.1.21 db2 update db cfg for sample using HADR_LOCAL_SVC DB2_HADR_1 db2 update db cfg for sample using HADR_REMOTE_HOST 10.1.1.22 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 db2 connect to sample db2 quiesce database immediate force connections db2 unquiesce database db2 connect reset 修改從服務(wù)器參數(shù)： db2 update db cfg for sample using HADR_LOCAL_HOST 10.1.1.22 db2 update db cfg for sample using HADR_LOCAL_SVC DB2_HADR_2 db2 update db cfg for sample using HADR_REMOTE_HOST 10.1.1.21 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 啟動(dòng)從HADR db2 deactivate database sample db2 start hadr on database sample as standby 啟動(dòng)主HADR db2 deactivate database sample db2 start hadr on database sample as primary 測(cè)試主服務(wù)器 db2 connect to sample db2 "create table tab1(col1 int,col2 int)" db2 "insert into tab1 values(1,1)" db2 "insert into tab1 values(1,1)" db2 "insert into tab1 values(1,1)" db2 terminate 在備用服務(wù)器上接管主服務(wù)器(以前的主將切換成從) db2 takeover hadr on database sample user db2inst1 using lsc123 db2 connect to sample db2 "select * from tab1" db2pd -hadr -db sample |
|
|
