9.1.2 Enabling client reroute in a HADR environment

For a client application to be transparently redirected to an alternate standby database server when there is a loss of communication with the primary database server, specify that alternate server's location on the primary database server. To do this, use the UPDATE ALTERNATE SERVER FOR DATABASE command in the primary database server. Example 9-7 is an example of the steps to specify an alternate database server.

Example 9-7 Enable ACR in DB2 HADR environment

(P) $ db2 update alternate server for database rmall using hostname salmon port 50000
(S) $ db2 update alternate server for database rmall using hostname rayden2 port 50000

The alternate database server information is stored on the primary database server, and loaded into the client's cache upon a successful connection to the primary database server. This means that for a client application to know the standby server, it must first successfully connect to the primary server.
xxxx