Configure your broker environment to globally coordinate message flow transactions with updates in DB2® databases under the control of a 32-bit queue manager.
To configure your broker environment for global coordination using a 32-bit queue manager as the transaction 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
ln -s <DB2_installation_directory>/lib/libdb2.a /var/mqm/exits/libdb2.a
ln -s <DB2_installation_directory>/lib/libdb2.a /var/mqm/exits/libdb2.a ln -s <DB2_installation_directory>/lib64/libdb2.a /var/mqm/exits64/libdb2.a
ln -s <DB2_installation_directory>/lib32/libdb2.a /var/mqm/exits/libdb2.a
ln -s <DB2_installation_directory>/lib32/libdb2.a /var/mqm/exits/libdb2.a ln -s <DB2_installation_directory>/lib64/libdb2.a /var/mqm/exits64/libdb2.a
ln -s <DB2_installation_directory>/lib/libdb2.sl /var/mqm/exits/libdb2.sl
ln -s <DB2_installation_directory>/lib/libdb2.sl /var/mqm/exits/libdb2.sl ln -s <DB2_installation_directory>/lib64/libdb2.sl /var/mqm/exits64/libdb2.sl
ln -s <DB2_installation_directory>/lib32/libdb2.sl /var/mqm/exits/libdb2.sl
ln -s <DB2_installation_directory>/lib32/libdb2.sl /var/mqm/exits/libdb2.sl ln -s <DB2_installation_directory>/lib64/libdb2.sl /var/mqm/exits64/libdb2.sl
ln -s <DB2_installation_directory>/lib/libdb2.so /var/mqm/exits/libdb2.so
ln -s <DB2_installation_directory>/lib/libdb2.so /var/mqm/exits/libdb2.so ln -s <DB2_installation_directory>/lib64/libdb2.so /var/mqm/exits64/libdb2.so
ln -s <DB2_installation_directory>/lib32/libdb2.so /var/mqm/exits/libdb2.so
ln -s <DB2_installation_directory>/lib32/libdb2.so /var/mqm/exits/libdb2.so ln -s <DB2_installation_directory>/lib64/libdb2.so /var/mqm/exits64/libdb2.so
ln -s <DB2_installation_directory>/lib/libdb2.so /var/mqm/exits/libdb2.so
On Linux on x86 and UNIX®:
XAResourceManager: Name=DB2 SwitchFile=install_dir/sample/xatm/db2swit XAOpenString=db=MyDataSource,uid=MyUserId,pwd=MyPassword,toc=t XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=DB2 SwitchFile=/opt/mqsi/sample/xatm/db2swit XAOpenString=db=MYDB,uid=wbrkuid,pwd=wbrkpw,toc=t XACloseString= ThreadOfControl=THREAD
On Windows®:
install_dir\sample\xatm\db2swit.dll
db=MyDataSource,uid=MyUserId,pwd=MyPassword,toc=t
db=MYDB,uid=wbrkuid,pwd=wbrkpw,toc=t
endmqm queue_manager_name strmqm queue_manager_name
When the queue manager restarts, check the queue manager's log for any 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.