Procedure
Configure the integration node queue manager with XA resource
manager information for each database that is involved in the transaction
that the queue manager will globally coordinate. - From the Start menu, open WebSphere MQ Explorer.
- Open the queue manager Properties dialog box, then open
XA resource managers.
- Click the Add button to create
a resource manager.
- In the Name field, enter a name to refer
to a resource manager.
- In the SwitchFile field, enter db2swit
- Copy the provided DB2 switch
files from the integration node install location to the
queue managers exits and exits64 directories
(by default under C:\Program Files (x86)\IBM\WebSphere
MQ).
Copy the file:
install_dir\server\sample\xatm\db2swit32.dll
into
the queue managers
exits directory,
and rename it to
db2swit.dll.
Copy
the file install_dir\server\sample\xatm\db2swit.dll
into
the queue managers exits64 directory.
- In the XAOpenString field, paste the following
string:
db=MyDataSource,uid=MyUserId,pwd=MyPassword,toc=t
- In the XAOpenString field, replace the
values with values that are appropriate for your configuration:
- MyDataSource is the name of the data
source to which you want to connect.
- MyUserId must be the user name that the integration node uses to connect to the
database.
You can define the user name that the integration node uses in a number of ways;
make sure that you specify the correct name in this file. The integration node determines the user name
by checking the following conditions in the order listed:
- A specific user name and password for this data source name (DSN),
that you have defined by running the mqsisetdbparms command.
- A default user name and password for all DSNs, that you have defined
by running the mqsisetdbparms command.
- The integration node service user
name, which you define with the -i parameter
on the mqsicreatebroker command
- MyPassword is the password that is
associated with the user name.
For example:db=MYDB,uid=wbrkuid,pwd=wbrkpw,toc=t
- Accept the default values for all the other fields on the page.
Stop then restart the queue manager
to apply the changes. To stop and restart the queue manager,
enter the following commands, where
queue_manager_name is
the name of the queue manager:
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\QMGR\errors,
where install_dir is
the location in which the integration node is
installed and QMGR is
the name of your WebSphere MQ Queue manager.
When the queue manager restarts successfully,
the changes that you made are applied.
Results
DB2 is
now configured for global coordination with the integration node
queue manager coordinating transactions.
What to do next
you can deploy globally coordinated message flows to
the integration node.