High Availability Failover in ESQL

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

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 will generate code that supports the HA Failover capability. The command line argument parser reads the -H flag and then, 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 (for UNIX), and the sql.ini (for Windows) 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.