If your message flow interacts with an Oracle 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:
Export EXTSHM=ON
db2set DB2ENVLIST=EXTSHM
db2stop
db2start
Stop the broker
Export EXTSHM=ON in the profile of all broker environments
Restart the broker
The toc (Thread of Control) specified in the XAOpenString determines the mode in which the Resource Manager (DB2) runs. The ThreadOfControl stanza specifies the mode in which the Transaction Manager (WebSphere MQ) runs. Specify explicit values to ensure that both run in THREAD mode.
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.
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.
On UNIX (AIX, HP-UX, Linux (x86 platform), and Solaris):
XAResourceManager: Name=DB2 SwitchFile=install_dir/sample/xatm/db2swit XAOpenString=db=yourdatabase,uid=youruserid,pwd=yourpassword,toc=t XACloseString= ThreadOfControl=THREAD
On Windows, set the following values on the Resources page of the properties dialog for your WebSphere MQ queue manager. This example assumes that you have installed WebSphere Message Broker in the directory C:\WMQI:
SwitchFile: C:\wmqi\sample\xatm\db2swit.dll XAOpenString=db=yourdatabase,uid=youruserid,pwd=yourpassword,toc=t ThreadOfControl=THREAD
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.
On UNIX (AIX, HP-UX, Linux (x86 platform), and Solaris):
ln –s install_dir/sample/xatm/db2swit /var/mqm/exits/db2swit
Include the following code in the XAResourceManager stanza in the qm.ini file
XAResourceManager: Name=DB2 SwitchFile=db2swit XAOpenString=db=yourdatabase,uid=youruserid,pwd=yourpassword,toc=t XACloseString= ThreadOfControl=THREAD
On Windows, set the following values on the Resources page of the properties dialog for your WebSphere MQ queue manager. This example assumes that you have installed WebSphere Message Broker in the directory C:\WMQI:
SwitchFile: C:\wmqi\sample\xatm\db2swit XAOpenString=db=yourdatabase,uid=youruserid,pwd=yourpassword,toc=t ThreadOfControl=THREAD
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.
The following examples show what you must include in the XAResourceManager stanza in the qm.ini file on UNIX systems.
On UNIX (AIX, HP-UX, and Solaris):
ln –s install_dir/sample/xatm/db2swit64 /var/mqm/exits64/db2swit64
Include the following code in the XAResourceManager stanza in the qm.ini file
XAResourceManager: Name=DB2 SwitchFile=db2swit64 XAOpenString=db=yourdatabase,uid=youruserid,pwd=yourpassword,toc=t XACloseString= ThreadOfControl=THREAD
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ac00900_ |