High Availability Failover in ESQL

The feature called High Availability Failover (HA Failover) is now supported on Embedded SQL/C and Embedded SQL/COBOL. For a list of the supported platforms, refer to Table 1. Its use is defined in the Open Client Embedded SQL/C Programmer’s Guide and in the Open Client Embedded SQL/COBOL Programmer’s Guide.

HA Failover allows a client to connect to a second server when a connection failure occurs to the primary server. When a flag (-H) is set, the precompilers generate code that supports the HA Failover capability. When the command line argument parser reads the -H flag, the precompiler checks for this flag in the code generation stage and generates the necessary Client-Library statements to implement HA Failover.

Similar to manually written Client-Library code, the second server must be up and running, and correctly listed in the interfaces file as an HA Failover server. Changes are necessary only if you want to generate code to implement the HA Failover capability.

To activate this feature, enter the following on the command line:

-H