When a connection is established over the XA interface, the UTM application can operate with several Oracle instances (databases). To do this, you must specify a separate open string for each instance. Each open string must be specified in a separate line in the start parameter file. The different instances are specified in the open strings.
The general syntax for start parameters of Oracle XA instances is:
.RMXA[xa-inst-name1] RM="Oracle_XA",OS="Oracle_XA[+DB=db-name1] ..." .RMXAxa-inst-name2 RM="Oracle_XA",OS="Oracle_XA+DB=db-name2 ..." .RMXAxa-inst-name3 RM="Oracle_XA",OS="Oracle_XA+DB=db-name3 ..."
Here the value of xa-inst-name1, xa-inst-name2, etc. must always match the generation value of the XA-INST-NAME parameter of an DATABASE statement of the KDCDEF generation.
Please observe the following three rules to ensure that the uniqueness of the assignment of XA instances to the UTM generation information is guaranteed in all cases:
Use at most one empty XA instance name and at most one empty Oracle DB name per UTM application.
All XA instance names must be unique in the UTM application.
All Oracle DB names must be unique in the UTM application.
Example
This example shows the connection of two Oracle XA databases to openUTM (BS2000).
Start parameters:
.RMXA RM="Oracle_XA",OS="Oracle_XA+Acc=P/*UTMUSER/*UTMPASS+SqlNet=RACSRV1+SesTm=60+DbgFl=0" .RMXAEVE RM="Oracle_XA",OS="Oracle_XA+DB=EVESDB+Acc=P/*UTMUSER/*UTMPASS+SqlNet=RACSRV2+SesTm=60+DbgFl=0"
The first start parameter contains only the prefix ".RMXA", i.e. an empty XA instance name, and is therefore assigned to the first database generated in openUTM without an XA-INST-NAME parameter.
The second start parameter contains the prefix ".RMXAEVE", i.e. the second XA instance is assigned to the generated database with XA-INST-NAME=EVE, and the access data generated for this ("Eve", etc.) is used by this XA Instance.
KDCDEF generation:
DATABASE TYPE=XA,ENTRY=XAOSWD,USERID='MaxTheSuperman',PASSWORD='PasswordOfMax' DATABASE TYPE=XA,ENTRY=XAOSWD,USERID='Eve',PASSWORD='PasswordOfEve',XA-INST-NAME=EVE