Automatic client reroute

The Sterling Selling and Fulfillment Foundation application uses the following DB2® JDBC URL to connect to one of the DB2 pureScale® members.

jdbc:db2://perfdb101:50000/ster_DB

After connecting, the DB2's Automatic Client Reroute (ACR) provides a list of the available cluster members to the DB2 JDBC driver. If a cluster member fails, the driver will automatically send transactions to the surviving members.

In addition to the ACR notification, the JCC driver provides the following parameters to allow you to specify a static list of alternate servers to the DB2 JDBC driver, so that the driver knows to which cluster member to attempt, if the member that the JDBC URL is pointing to is slow.
You can set these parameters for agent and integration servers with the following parameters in the JDBC property file:
In the WebSphere® Application Server administrative console, DB2 automatic client reroute options section, use the following fields to enable client rerouting: