We are testing what happens if the primary server is disconnected from network and how to get the standby server to take over the primary role.
It works well if there isn't database activity which occurs seldom.
If there is database activity and we issue the command
db2 takeover hadr on db db_name by force
error message SQL1770N with reason code 3 appears.
Then we write
db2 takeover hadr on db db_name by force peer window only
and receive error message SQL1770N with reason code 9.
Rc 3 looks strange. Do you really get rc 3 on takeover by force? http://www.ibm.com/support/knowledge...sql01770n.html
If yes, did you try to allow the standby to reach the end of backup point in time before running the takeover command?
What's the state of the standby when you get rc 3?