Read only on DB2 HADR server not working
Running DB2 10.5 on Windows
We have a DB2 10.5 HADR server set up that I should be able to use for read only queries. I can connect to it (using TOAD), but when I do any selects from any table I get the following.
Lookup Error - DB2 Database Error: ERROR [] [IBM][DB2/NT64] SQL1773N The statement or command failed because it requires functionality that is not supported on a read-enabled HADR standby database. Reason code = "1".
I checked the DB2_HADR_ROS registry entry and it is set to ON as it should be.
Has anyone else run into this?
Thank you!
Jim
We have a DB2 10.5 HADR server set up that I should be able to use for read only queries. I can connect to it (using TOAD), but when I do any selects from any table I get the following.
Lookup Error - DB2 Database Error: ERROR [] [IBM][DB2/NT64] SQL1773N The statement or command failed because it requires functionality that is not supported on a read-enabled HADR standby database. Reason code = "1".
I checked the DB2_HADR_ROS registry entry and it is set to ON as it should be.
Has anyone else run into this?
Thank you!
Jim
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi!
The error cleary states what is wrong see the manual.
Try the same query but add "with ur" at the end.
If that works issue in a DB2 command window (on windows ) or as instance owner following command
db2set DB2_STANDBY_ISO = UR
See the "Isolation level on Standby" section here for more info.
Regards,
Tomas Helgi
The error cleary states what is wrong see the manual.
1 ) An isolation level other than UR is used and the DB2_STANDBY_ISO registry variable is turned off.
Try the same query but add "with ur" at the end.
If that works issue in a DB2 command window (on windows ) or as instance owner following command
db2set DB2_STANDBY_ISO = UR
See the "Isolation level on Standby" section here for more info.
Regards,
Tomas Helgi
ASKER
Yes, I figured that out. I disagree that the error clearly states it. When I googled the message that little tidbit did not pop up. The first thing that pops up is
https://www.ibm.com/developerworks/data/library/techarticle/dm-1205hadrstandby/
which does not mention that at all. Like I said, I am new to this and IBM has so many pages (windows and unix) and it is very confusing.
Thank you very much for your time. I really do appreciate it!!!!
https://www.ibm.com/developerworks/data/library/techarticle/dm-1205hadrstandby/
which does not mention that at all. Like I said, I am new to this and IBM has so many pages (windows and unix) and it is very confusing.
Thank you very much for your time. I really do appreciate it!!!!
ASKER