I followed the instructions given in this following IBM documenation to enable "automatic client reroute" to a database which is HADR enable.
Configuring automatic client reroute and High Availability Disaster Recovery (HADR) - IBM DB2 9.7 for Linux, UNIX, and Windows
My HADR is working fine, however when secondary database takesover as Primary, and if I try to connect, my connection is not not getting rerouted. I see following error
SQL1776N The command cannot be issued on an HADR standby database. Reason
code = "1".
Any suggestions would be of great help.
Thanks,
- G's