Configure your broker environment to globally coordinate message flow transactions with updates in DB2® databases under the control of your broker queue manager.
For more information about TCP/IP connections, see the example in the section about message SQL1224N in Resolving problems when using databases.
To enable shared memory:
mqsistop broker
export EXTSHM=ON
mqsistart broker
XAResourceManager:
Name=DB2
SwitchFile=db2swit
XAOpenString=db=MyDataSource,uid=MyUserId,pwd=MyPassword,toc=t
XACloseString=
ThreadOfControl=THREAD
The switch file is supplied by IBM® Integration Bus.
This parameter is valid only for brokers that you have migrated from previous releases.
XAResourceManager:
Name=DB2
SwitchFile=db2swit
XAOpenString=db=MYDB,uid=wbrkuid,pwd=wbrkpw,toc=t
XACloseString=
ThreadOfControl=THREAD
endmqm queue_manager_name
strmqm queue_manager_name
When the queue manager restarts, check the queue manager log for all warnings that are associated with the restart. The log files are located in /var/mqm/qmgrs/queue_manager_name/errors, where queue_manager_name is the name of the queue manager that you restarted.
When the queue manager restarts successfully, the changes that you made to qm.ini are applied.install_dir\sample\xatm\db2swit.dll
db=MyDataSource,uid=MyUserId,pwd=MyPassword,toc=t
This parameter is valid only for brokers that you have migrated from previous releases.
db=MYDB,uid=wbrkuid,pwd=wbrkpw,toc=t
endmqm queue_manager_name
strmqm -si queue_manager_name
When the queue manager restarts, check the queue manager log for all warnings that are associated with the restart. The log files are located in install_dir\WebSphere MQ\Qmgrs\IB9QMGR\errors, where install_dir is the location in which the broker is installed.
When the queue manager restarts successfully, the changes that you made are applied.install_dir\sample\xatm\db2swit32.dll
into
the queue managers exits directory, and rename it to db2swit.dll.install_dir\sample\xatm\db2swit.dll
into
the queue managers exits64 directory.db=MyDataSource,uid=MyUserId,pwd=MyPassword,toc=t
This parameter is valid only for brokers that you have migrated from previous releases.
db=MYDB,uid=wbrkuid,pwd=wbrkpw,toc=t
endmqm queue_manager_name
strmqm -si queue_manager_name
When the queue manager restarts, check the queue manager log for all warnings that are associated with the restart. The log files are located in install_dir\WebSphere MQ\Qmgrs\IB9QMGR\errors, where install_dir is the location in which the broker is installed.
When the queue manager restarts successfully, the changes that you made are applied.