Linking to a Resource Manager on Unix, Linux and Windows systems

openUTM is linked with Resource Managers (e.g. database systems) via the XA interface standardized by X/Open. It coordinates the transactions of openUTM with the services of the Resource Manager. The XA interface is supported in the CAE version of the XA interface (XA-CAE).

openUTM for Unix, Linux and Windows systems supports coordination with the data base system Oracle.

RMXA statement in section "RMXA - define a name for an XA (database) connection (Unix, Linux and Windows systems)" The Resource Manager to which openUTM is to be linked and the version of the XA interface via which the link is to be made must be defined in the generation with the RMXA statement:

• XASWITCH=

  Name of the xa_switch_t structure of the Resource Manager, which is made known to openUTM.

• USERID= and PASSWORD=

  User name and password for the database system, supported only for Oracle databases.

  Alternatively, the user name and the password can be transferred to the database system by means of start parameters.

  It is possible to modify the user name and/or the password by means of dynamic administration.

• XA-INST=

  Name of the XA instance.

The following must be noted for the linked operation of openUTM with XA:

• Several Resource Managers (i.e. database systems) can be served within a UTM application.

• When multiple instances are to be generated, these must be defined with the same xa_switch and different instance names (XA-INST operand).

• The simultaneous operation of several entities (databases) of a Resource Manager (database system) is possible provided the Resource Manager supports multi-instance mode. The databases with which the UTM application is linked are determined by corresponding start parameters for the application. For multi-instance mode, you must define several RMXA statements and specify several open strings at the start.

Below is a description of how you must generate the linking of your UTM application with the Resource Manager. The database-specific names specified here (xa_switch_t structure) may change, which is why you should check that the specifications are correct. For more information, see the documentation for the database systems.

Linking with Oracle

RMXA XASWITCH=xaosw,USERID= ...

or

RMXA XASWITCH=xaoswd,USERID= ...

Detailed examples are provided in openUTM manual “Using UTM Applications on Unix, Linux and Windows Systems” under the heading "Start parameters for a UTM database application".

When the dynamic XA connection is used on Windows systems, the link between Oracle and openUTM must be configured in addition in the Windows Registry. Details siehe openUTM manual “Using UTM Applications on Unix, Linux and Windows Systems”, Stichwort „UTM-Datenbank-Anschluss generieren“.