Configuring the Resource Manager
As explained in Using the DB XA Module Database Classes, XA connections to your database are established by using the database()
function in RWDBManager, and providing its propertyString
parameter with key XA=xaParameter
. This section explains how you obtain the Sybase-specific value of the xaParameter
argument.
When you run on Sybase, the value of the xaParameter
argument must be the same as that used for the lrm_name
parameter, which indicates the logical resource manager (LRM) name that the TPM uses to open the database. The open string for the Sybase database takes the following form:
-Nlrm_name
-Uusername
-Ppassword
[-Llogfile_name
] [-Ttraceflags
] [-Vversion
]
The required parameters include:
lrm_name
: Each XA application connects to the server using a LRM Name. This LRM Name need not be unique for each XA application. The number of applications using the same LRM Name is restricted only by the CS_MAX_CONNECT
property in the [all]
section of the XA configuration file, as shown here:
[all]
logfile=/nfs/homes/user/xa_log
traceflags=xa
properties=CS_MAX_CONNECT=5
Note that the value of this parameter is the same value that you provide in the argument XA=xaParameter
when defining the propertyString
parameter in RWDBManager::database()
(see RWDBDatabase Objects). This LRM name should also be present in the XA configuration file, as shown here:
[xa]
lrm=mylrm
server=SYBASE120
username
: user name to connect to the database.
password
: password for the corresponding username
.
For more information on the open string parameters, both required and optional, please refer to the XA Interface Integration Guide for CICS, Encina and Tuxedo.