Home

 

Adding resource manager configuration information for DB2

 

The next step is to modify the configuration information for the queue manager, as described in Adding configuration information to the queue manager, to declare DB2 as a participant in global units of work.

• On Windows and Linux (x86 platform) systems use the WebSphere MQ Explorer. Specify the details of the switch load file in the queue manager properties panel, under XA resource manager.

• On all other systems specify the details of the switch load file in the XAResourceManager stanza in the queue manager's qm.ini file.

Figure 1 is a UNIX sample, showing an XAResourceManager entry where the database to be coordinated is called mydbname, this name being specified in the XAOpenString:

Figure 1. Sample XAResourceManager entry for DB2 on UNIX platforms

XAResourceManager:
  Name=mydb2
  SwitchFile=db2swit
  XAOpenString=mydbname,myuser,mypasswd,toc=t
  ThreadOfControl=THREAD

1. ThreadOfControl=THREAD cannot be used with DB2 versions prior to version 8. It is recommended that you always set ThreadOfControl and the XAOpenString parameter toc to one of the following combinations:

   • ThreadOfControl=THREAD and toc=t

   • ThreadOfControl=PROCESS and toc=p

   If you are using the jdbcdb2 XA switch load file to enable JDBC/JTA coordination, use ThreadOfControl=PROCESS and toc=p.

 

Parent topic:

DB2 configuration

fa13600_

 

Home