Connecting to Multiple Servers
Support for multiple JDBC Servers and/or Data servers is available on the CDD server name fields and the JDBC connection string.
servername[:port][!servername[:port]][!servername[:port]]...[!DISTRIBUTE]
For example, if you have two JDBC servers set up for redundancy - one on a server called PRIMARY, listening on port 7323, and another server called SECONDARY, listening on port 8754, the gateway server name would be:
PRIMARY:7323!SECONDARY:8754
When a list of servers is provided, CONNX starts with the first server listed. If the connection fails for that server, it then serially loop through all the servers from that point forward, wrapping back around to the beginning if necessary, until all options are exhausted, or a successful connection is established.
If you use the DISTRIBUTE option, CONNX randomly chooses a server from the list initially. If the connection fails for that server, it will then serially loop through all the servers from that point forward, wrapping back around to the beginning if necessary, until all options are exhausted, or a successful connection is established. This is used for load balancing purposes.