HADR itself does not presently support multiple standby sites for one
database. However, the kind of configuration you discuss can be
supported by a combination of traditional failover (i.e.,
shared/multi-ported disk plus cluster manager) locally and HADR across
the distance.
That is, you can configure the HADR primary on a cluster that supports
in-cluster failover for the DB2 server, while the HADR standby is
configured at a remote site (either w/ or w/o local failover for the
standby, but of course we prefer to see analogous configuration of the
standby).
Regarding JDBC configuration, I think you are probably asking about how
to set up Automatic Client Reroute for that client. ACR can be set up
on the server for all clients, but the universal driver also provides
the ability to set it up at the client itself (helpful in some cases,
as the server-side support doesn't kick in until a first successful
connection is made by the client whereas the driver can reroute if the
very first connection attempt itself fails).
Here are a few references for ACR, including some driver specific setup
info:
JDBC driver side:
*
http://www-1.ibm.com/support/docview...id=swg21177732
* Search for string "Rerouting DB2 Universal JDBC driver clients" in
the right-hand panel here:
http://publib.boulder.ibm.com/infoce...e/r0012130.htm
Server side:
http://publib.boulder.ibm.com/infoce...n/c0011423.htm
New (general) developerWorks article on ACR:
http://www-128.ibm.com/developerwork...512zikopoulos/
Regards,
- Steve P.
--------------------------
Steve Pearson
IBM DB2 UDB for LUW Development
Portland, OR, USA