When a failover or a failback occurs, all existing client connections are lost. Clients do not see any difference between the two events. However, the client connection failover happens differently, depending on the type of connection the client has established with Adaptive Server. Client connections are either high availability connections or non-high-availability connections.
High availability connections must have the CS_HAFAILOVER
property set in the connection handle, and the hafailover entry
in the interfaces file. For clients that use
the high availability connection, fail over is transparent; the broken
connections are automatically reestablished when the Adaptive Server restarts
on the secondary node. However, the client must resubmit any uncommitted
transactions.
non-high-availability connections do not reconnect automatically; clients must first reestablish their connections to Adaptive Server, then resubmit uncommitted transactions.
For more information see “Configuring the interfaces file on the client side”.
