请问一下:
1.HADR的典型最佳实践案例?
2.切换方式与案例?同步时延,基础环境条件(网络带宽、数据量、交易并发量)?
3.如果故障交易从主机切至备机,那同步机制如何变化?以及如何切换后回切?
db2haicu -disable
db2pd -db xxx -hadr
Shutdown the HADR operation
A: Deactivate the primary database
db2 deactivate database sample
B: Stop DB2 on the primary database
db2stop force
C: Deactivate the standby database
db2 deactivate database sample
D: Stop DB2 on the standby database
db2stop
Start the HADR operation
A: db2 activate database sample ----standby database
or
db2 start hadr on database sample as standby
B: db2 activate database sample ----primary database
or
db2 start hadr on database sample as primary
or
db2 connect to sample
db2haic带有HADR环境的升级
Primary server:
先把HADR切换到secondary server(在secondary server, TAKEOVER HADR ON DATABASE)
deactivate database
db2stop
install fixpack/upgrade
db2start
db2 activate database <db_name> u -enable