Create an XA Resource

Your enterprise server region requires an XA resource for each datastore that contains one or more transactional files. If the database containing the datastore is also used by other COBOL applications, additional XA resources are required. Refer to Working with Multiple XARs for details on how to handle such situations.

  1. Open the ESCWA Administration page, and then select the enterprise server that references the transactional data file from the left-hand pane.
  2. In the right-hand pane, click General > XA Resources.
  3. Click NEW.
  4. Specify the following XAR details:
    Option Description
    ID Unique ID for the XAR
    Name Unique name for the XAR
    Module Specify the location of the RM switch module executable file (.dll on Windows or .so on UNIX platforms). This is database specific: esmssql.dll/.so for MSSQL and Azure SQL, ESPGSQLXA.dll/.so for PostgreSQL, and ESDB2XA.dll/.so for Db2. Refer to Building RM Switch Modules for more information.
    Enabled Enable the resource for immediate use.
    Open string DSN=<datastore-dsn>

    where <datastore-dsn> is the ODBC data source name of the datastore you are configuring.

    Note: These are only the mandatory options required, with the addition of USRPASS=userid.password if you are using a PostgreSQL database. You can also specify further options as required, as detailed in To define an XA resource (XAR) for an enterprise server region.
  5. Click SAVE.

    The XA resource should be effective immediately.

You can now proceed to configuring your CICS or batch (JCL) applications to use the file(s) in the datastore.