Identifying an alternate server for automatic client reroute
Whenever a Db2® server or Db2 Connect server crashes, each
client that is connected to that server receives a communications error which terminates the
connection resulting in an application error.
In cases where availability is important,
implement either a redundant set-up or the ability to fail the server over to a standby node. In
either case, the Db2 client code attempts
to re-establish the connection to the original server which might be running on a failover node (the
IP address fails over as well), or to a new server.
Procedure
To define a new or alternate server, use the UPDATE
ALTERNATE SERVER FOR DATABASE or UPDATE ALTERNATE
SERVER FOR LDAP DATABASE command.
These commands update the alternate server information for a database alias in the system database directory.