Start parameters for a UTM database application with XA support

openUTM also supports the XA functionality for connections to database systems on BS2000 systems. The functionality when using traditional database systems on a BS2000 system is not affected by this (e.g. UDS/SQL, SESAM/SQL or LEASY).

The start parameters have the following general format:

.RMXA RM="...",OS="openstring",CS="closestring"

openstring

The format of openstring is database-specific and is described in the documentation for the database system. There you will also find the meanings of the individual parameters in the open string. openUTM passes the strings from the start parameter file to the database system without checking them.

The start parameters for a UTM-Oracle application, for example, have the following format:

.RMXA RM="Oracle_XA",OS="openstring"

At connection setup openUTM automatically replaces the generic placeholders
*UTMUSER and *UTMPASS by the user ID and the password which were generated in the RMXA statement.

Additional parameters are required for failover support in the Oracle^® Real Application Cluster; see "Start parameters for failover with Oracle® Real Application Clusters".

Specifying access data for the database

You can specify the access data for the database (user name, password) either in the start parameters or in the UTM generation, whereby the following applies:

• Specification in the start parameters takes priority over UTM generation. You can either specify both user name and password or just the password or just the user name. In all three cases, the message K238 is output when starting the UTM application.

• If you want to use the access data from UTM generation (see "Using the Oracle user name and Oracle password from the UTM generation"), you must specify the placeholders *UTMUSER (for the user name) and *UTMPASS (for the password) in the start parameters. When establishing a connection, openUTM automatically replaces the generic placeholders *UTMUSER and *UTMPASS with the user name and password generated in the DATABASE statement.

For security reasons, storing the access data in the UTM generation is recommended.

The access data can be changed later by administration.

Example for the connection to an Oracle XA database

Start parameters:

.RMXA RM="Oracle_XA",OS="Oracle_XA+Acc=P/*UTMUSER/*UTMPASS+SqlNet=RACSERVICE1+SesTm=60+DbgFl=0"

Appropriate KDCDEF generation:

DATABASE TYPE=XA,ENTRY=XAOSWD,USERID='MaxTheSuperman',PASSWORD='PasswordOfMax'