DB2 9.7 Fixpack 1 于2009-11-26发布，DB2开始支持 HADR Read Only Standby
周五下载后，自己测了一下先
[@more@]<-不好意思，混杂英文。->
1）如何启动 HADR 可读备机？
First, you need to set DB2_HADR_ROS=ON on standby.
db2set DB2_HADR_ROS=ON
Then, start standby as usual:
db2 start hadr on db sample as standby
DB20000I START HADR ON DATABASE 命令成功完成。
db2 connect to sample
......
db2 "select * from staff"
ID NAME DEPT JOB YEARS SALARY COMM
------ --------- ------ ----- ------ --------- ---------
SQL1773N 启用了读操作的 HADR
备用数据库不支持此语句或命令所需的功能。原因码："1"。
2) 如何设置 ISOLATION level
a. set ISOLATION level at statement level
db2 "select * from staff with ur"
ID NAME DEPT JOB YEARS SALARY COMM
------ --------- ------ ----- ------ --------- ---------
10 Sanders 20 Mgr 7 98357.50 -
......
b. set default ISOLATION level to UR:
db2set DB2_STANDBY_ISO=UR
need to recycle instance
db2 "select * from staff"
ID NAME DEPT JOB YEARS SALARY COMM
------ --------- ------ ----- ------ --------- ---------
10 Sanders 20 Mgr 7 98357.50 -
......
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8481986/viewspace-1029196/ ，如需转载，请注明出处，否则将追究法律责任。
