Home / server / Questions / 920446
In Process
Aljaz Vidmar
Asked: 2018-07-12 02:53:51 +0800 CST

DB2 10.5 HADR read only standby applications don't reconnect to primary

  • 772

Scenario:

server SERV_A, database DBNAME primary

server SERV_B, database DBNAME standby with DB2_HADR_ROS enabled

Then this situation occurs:

  1. connection CON is made from client to DBNAME when primary is on SERV_A
  2. takeover DBNAME to SERV_B -> DBNAME becomes primary on SERV_B
  3. connection is rerouted with ACR (Automatic Client Reroute) to SERV_B
  4. takeover DBNAME back to SERV_A -> DBNAME becomes primary on SERV_A
  5. Connection CON does not goes back to SERV_A but remains connected to SERV_B in readolny mode.

How to avoid this situation? The active connection remains on standby database in read only mode until you restart the connection. Even worse with some apps which are using connection pools (Websphere Application Server) when you have to restart the entire application server to force the connection pool to first connect to primary server.

This occurs with ibm db2 dsdriver with ACR configured, jdbc driver type 4. Tested on multiple versions (fixpacks) of db2 10.5 and 11.

high-availability

2 Answers

  1. ACR is not supported with reads on standby feature.

    Reads on standby restrictions

    Use VIPs.

    • 0

  2. Have you tried this with TSAMP configured with a VIP? It has been years since I've seen someone try to rely only on ACR without TSAMP.

    • -2