parm_id1 = parm_value,parm_id2 = parm_value, ...
It
does not matter in what order these parameters are specified. Valid
values for parm_id are described in the following
section. The xa_open string TPM parameter and the tp_mon_name database manager configuration parameter are used to indicate to DB2 for Linux, UNIX, and Windows which TP monitor is being used. The tp_mon_name value applies to the entire DB2 instance. The TPM parameter applies only to the specific XA resource manager. The TPM value overrides the tp_mon_name parameter. Valid values for the TPM and tp_mon_name parameters are as follows:
TPM Value | TP Monitor Product | Internal Settings |
---|---|---|
CICS® | IBM TXSeries CICS |
|
MQ | IBM MQSeries® |
|
CB | IBM Component Broker |
|
SF | IBM San Francisco |
|
TUXEDO | BEA Tuxedo |
|
MTS | Microsoft Transaction Server | It is not necessary to configure DB2 for Linux, UNIX, and Windows for MTS. MTS is automatically detected by the ODBC driver in DB2 for Linux, UNIX, and Windows. |
JTA | Java™ Transaction API | It is not necessary to configure DB2 for Linux, UNIX, and Windows for Enterprise Java Servers (EJS) such as IBM WebSphere®. The JDBC driver in DB2 for Linux, UNIX, and Windows automatically detects this environment. Therefore this TPM value is ignored. |
Earlier versions of DB2 for Linux, UNIX, and Windows used the xa_open string format described here. This format is still supported for compatibility reasons. Applications should be migrated to the new format when possible.
"database_alias,userid,password"
The database_alias is
required to specify the alias name of the database. The alias name
is the same as the database name unless you explicitly cataloged an
alias name after you created the database. The userid and password are
optional and, depending on the authentication method, are used to
provide authentication information to the database. db2 update dbm cfg using tp_mon_name CICS
For
each database defined to CICS in
the Region—> Resources—> Product—> XAD—> Resource
manager initialization string, specify: db=dbalias,uid=userid,pwd=password
db=dbalias,uid=userid,pwd=password,tpm=cics
db2 update dbm cfg using tp_mon_name MQ
For
each database defined to CICS in
the Region—> Resources—> Product—> XAD—> Resource
manager initialization string, specify: uid=userid,db=dbalias,pwd=password
uid=userid,db=dbalias,pwd=password,tpm=mq
pwd=password,uid=userid,tpm=cics,db=dbalias
db=dbalias,uid=userid,pwd=password,tpm=mq
db2 update dbm cfg using tp_mon_name myaxlib
and,
for each database defined to the XA TM, specifying an xa_open string:
db=dbalias,uid=userid,pwd=password
db=dbalias,uid=userid,pwd=password,axlib=myaxlib
db=dbalias,uid=userid,pwd=password,axlib=myaxlib,chain_end=T
db=dbalias,uid=userid,pwd=password,axlib=myaxlib,chain_end