EDB PostgreSQL RM Switch Module

Provides the information required to build the EDB PostgreSQL RM switch module.

Restriction: This topic applies only when the Enterprise Server feature is enabled.

Note: This is a technology preview feature only. It is being made available to allow you to test and provide feedback on this new capability; however, this feature is not intended for production use and it is not supported as such. Furthermore, Micro Focus does not guarantee that this feature will be delivered at a GA level and if it is, then the functionality provided might differ considerably from this technology preview.

Source Code

The EDB PostgreSQL RM switch module COBOL source file, ESPGSQL.CBL is located by default in the $COBDIR/src/enterpriseserver/xa directory.

Note: If you prefer to supply user credentials programatically rather than in the xa_open string, instructions for doing so are provided in the COBOL source file in the Customization section.

Build Requirements

The build script uses the current effective working mode to determine how to build the switch module.

Building the Switch Module

The $COBDIR/src/enterpriseserver/xa directory contains the build script file that you can use to build the switch module.

Copy all files from the $COBDIR/src/enterpriseserver/xa directory (default location) to any location where you have WRITE permission.
Change to the directory containing the copied files.
Enter build pg

Build Output

The build process produces four binary RM switch module files from the ESPGSQLXA.CBL COBOL source file:

ESPGSQLXA.so	32-bit	dynamic
ESPGSQLXA64.so	64-bit	dynamic
ESPGSQLXA_S.so	32-bit	static
ESPGSQLXA64_S.so	64-bit	static

You can register an RM switch module with Enterprise Server dynamically, or register it statically depending on which binary file you use. We recommend that you use the dynamic switch module option, as this ensures that only active databases used in the global transaction participate in the TM/RM XA flow.

Additional Resources: For more information on using the EDB PostgreSQL RM switch module, including the xa_open string definition, see EDB PostgreSQL xa_open string.