This topic has been locked.
Pinned topic DB2 9.7 HADR Problem
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
I tried to make hadr with DB2 9.7 and latest fixpack. Everyting seems to be ok, but when I press TAKEOVER button it shows error SQL1770N Takeover HADR cannot complete. Reason code = "4" Does anybody know how to solve this problem?
Re: DB2 9.7 HADR Problem2012-12-14T12:11:51ZThis is the accepted answer. This is the accepted answer.Hi,
Have you looked at the help for the error?
The explanation corresponding to the reason code is:
The command was issued against a standard or HADR primary
This command is not supported on a standard or HADR primary
database. Issue the command on an HADR standby database only.
You need to run takeover on the sby
Re: DB2 9.7 HADR Problem2012-12-14T13:19:56ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
Yes that is also correct, unless you are using ROS ( Read On Sby ). Just run this in the sby side: db2 takeover hadr on db xxx
Where xxx is the db name. You don't need to make an explicit connection prior to running takeover
Re: DB2 9.7 HADR Problem2012-12-14T14:09:13ZThis is the accepted answer. This is the accepted answer.use command line instead of controle centre
Re: DB2 9.7 HADR Problem2012-12-14T14:09:22ZThis is the accepted answer. This is the accepted answer.use command line instead of control centre
Taml 0600026E7A5 Posts