If your message flow interacts with a database, and you want to coordinate the updates made to the database with other actions within the message flow, configure your broker to manage these updates.
Before you start:
To complete this task, you must have completed the following task:
Update the broker queue manager information by defining an XAResourceManager stanza for each of the databases that will participate in globally coordinated transactions when updated by message flows on that broker.
If your message flows reference message dictionaries, or contain Publication nodes, you must also define an XAResourceManager stanza for the broker internal database using the same method.
If you want to use DB2 in coordinated transactions:
If you prefer to build your own files, follow the instructions in the section called "DB2 configuration" in the WebSphere MQ System Administration Guide. You can also find details of how to configure XA resource definitions in this book.
If you want to use Oracle in coordinated transactions, follow the general instructions in the section called "Oracle configuration" in the WebSphere MQ System Administration book, and use these with the instructions given here. In particular, you must provide a symbolic link to the 32-bit Oracle client library libclntsh from /usr/lib.
grant select on DBA_PENDING_TRANSACTIONS to <userid>;
The following examples show what you must include in the XAResourceManager stanza in the qm.ini file on UNIX systems, and the equivalent information for Windows:
XAResourceManager:
Name=Oracle8
SwitchFile=/usr/opt/wmqi/merant/lib/UKor8dtc18.so
XAOpenString=ORACLE_XA+SQLNET=myserver+ACC=P/scott/tiger+sestm=0+
threads=TRUE+DB=ORACLEDB
XACloseString=
ThreadOfControl=THREAD
XAResourceManager:
Name=Oracle8
SwitchFile=/opt/wmqi/merant/lib/libSwitchOracle.sl
XAOpenString=ORACLE_XA+SQLNET=myserver+ACC=P/scott/tiger+sestm=0+
threads=TRUE+DB=ORACLEDB
XACloseString=
ThreadOfControl=THREAD
You must run the following command (including the initial period and the space that follows it) before you start a queue manager that you have configured in this way:
. /opt/wmqi/sample/profiles/profile.hpux
XAResourceManager:
Name=Oracle8
SwitchFile=/opt/wmqi/merant/lib/UKor8dtc18.so
XAOpenString=ORACLE_XA+SQLNET=myserver+ACC=P/scott/tiger+sestm=0+
threads=TRUE+DB=ORACLEDB
XACloseString=
ThreadOfControl=THREAD
SwitchFile: C:\WMQI\BIN\UKor8dtc18.dll
XAOpenString: ORACLE_XA+SQLNET=myserver+ACC=P/scott/tiger+sestm=0+
threads=TRUE+DB=ORACLEDB
ThreadOfControl: THREAD
If you want to use Sybase in coordinated transactions, follow the general instructions in the section called "Sybase configuration" in the WebSphere MQ System Administration book, and use these with the instructions given here. WebSphere Business Integration Message Broker supports only Sybase Version 12.
The following examples show what you must include in the XAResourceManager stanza in the qm.ini file on UNIX systems, and the equivalent Windows information. In each example, uid represents the user login and pwd the user ID's password.
XAResourceManager:
Name=SYBASEXA
SwitchFile=/usr/opt/wmqi/merant/lib/UKase18.so
XAOpenString=-NSYBASEDB -A10.30.14.72,5000 -WWinsock -Uuid -Ppwd -K2
XACloseString=-NSYBASEDB -A10.30.14.72,5000 -WWinsock -Uuid -Ppwd -K2
ThreadOfControl=THREAD
XAResourceManager:
Name=SYBASEXA
SwitchFile=/opt/wmqi/merant/lib/libSwitchSybase.sl
XAOpenString=-NSYBASEDB -A10.30.14.72,5000 -WWinsock -Uuid -Ppwd -K2
XACloseString=-NSYBASEDB -A10.30.14.72,5000 -WWinsock -Uuid -Ppwd -K2
ThreadOfControl=THREAD
You must run the following command (including the initial period and the space that follows it) before you start a queue manager that you have configured in this way:
. /opt/wmqi/sample/profiles/profile.hpux
XAResourceManager:
Name=SYBASEXA
SwitchFile=/opt/wmqi/merant/lib/UKase18.so
XAOpenString=-NSYBASEDB -A10.30.14.72,5000 -WWinsock -Uuid -Ppwd -K2
XACloseString=-NSYBASEDB -A10.30.14.72,5000 -WWinsock -Uuid -Ppwd -K2
ThreadOfControl=THREAD
SwitchFile: C:\WMQI\BIN\UKase18.dll
XAOpenString: -NSYBASEDB -A10.30.14.72,5000 -WWinsock -Uuid -Ppwd -K2
XACloseString: -NSYBASEDB -A10.30.14.72,5000 -WWinsock -Uuid -Ppwd -K2
ThreadOfControl: THREAD
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ac00396_ |