WebSphere Message Brokers
File: ah13850_
Writer: Kate Hostler

Task topic

This build: July 31, 2007 21:30:07

Changing the ODBC connection and XA resource manager definitions for a migrated broker

Update definitions for Oracle and Sybase databases.

WebSphere Message Broker Version 6.1 includes new versions of the ODBC drivers that are supplied by DataDirect Technology (formerly Merant). These ODBC drivers are for Oracle and Sybase databases. A new version of the DataDirect Driver Manager for Linux and UNIX systems is also included. You must make a number of changes as a result of these new versions of the ODBC drivers for Oracle and Sybase databases.
  • If you are migrating a broker from Version 5.0 to Version 6.1 on a Windows system, update the ODBC definition for each broker and the user data source name as described below. Complete this task for Oracle and Sybase databases only.
  • If you are migrating a broker from Version 5.0 to Version 6.1 on Linux or UNIX systems, create a new ODBC configuration file that contains definitions for each of your existing data sources. Use the Version 6.1 template to complete this task, as described in Connecting to a database from Linux and UNIX systems. Do not change the existing definition file.
  • You must also change the XA resource manager definition for the database if you have a message flow that is running in the broker and updates an Oracle or Sybase database within a global unit of work that is coordinated by the broker queue manager.
  • If you are reverting a broker from Version 6.1 back to an earlier version, you must reverse these changes.

Make the required changes before you run the Version 6.1 mqsimigratecomponents command. If you are reverting to an earlier version, keep the new definitions until after you have finished running the mqsimigratecomponents command. The following sections describe the changes in detail.

Changing the ODBC connection definitions

Linux and UNIX systems

Create a new ODBC definitions file by following the instructions in Connecting to a database from Linux and UNIX systems. Before you run the Version 6.1 commands, check that your ODBCINI environment variable points to the new file and not to the existing file.

Windows systems

To change the ODBC connection definitions on a Windows system:
  1. Open the ODBC Data Source Administrator window.
  2. Open the System DSN page.
  3. For each Oracle and Sybase database that is accessed by the broker, associate the data source name with the new ODBC driver:
    1. Delete the data source by clicking Remove.
    2. Re-create the data source with the new ODBC driver by clicking Add.
The following table displays the name of the new ODBC driver for each database management system (DBMS).
DBMS New ODBC driver
Oracle MQSeries DataDirect Technologies 5.20 32-BIT Oracle
Sybase MQSeries DataDirect Technologies 5.20 32-BIT Sybase Wire Protocol

Changing the XA resource manager definitions

To change the XA resource manager definitions on a Linux or UNIX system, edit the queue manager configuration file (qm.ini) of the broker queue manager. This file is in the queue manager's directory.

In the XAResourceManager stanza for each Oracle and Sybase database that participates in a global unit of work, coordinated by the broker queue manager, change the entry for the switch file. The following tables specify what you need to change for each broker operating system and database management system (DBMS).

Complete the following changes on AIX.
DBMS Change ... To ...
Oracle
SwitchFile= 
  /usr/opt/mqsi/merant/lib/UKor8dtc18.so
or
SwitchFile= 
  /usr/opt/mqsi/merant/lib/UKor8dtc20.so
or
SwitchFile=UKor8tdc20.so
SwitchFile=UK0r8dtc22.so
Sybase
SwitchFile= 
  /usr/opt/mqsi/merant/lib/UKase18.so
or
SwitchFile= 
  /usr/opt/mqsi/merant/lib/UKasedtc20.so
or
SwitchFile=UKasedtc20.so
SwitchFile=UKasedtc22.so
Complete the following changes on Solaris and Linux.
DBMS Change ... To ...
Oracle
SwitchFile= 
  /opt/mqsi/merant/lib/UKor8dtc18.so
or
SwitchFile= 
  /opt/mqsi/merant/lib/UKor8dtc20.so
or
SwitchFile=UKor8tdc20.so
or
SwitchFile=UKoradtc20.so
SwitchFile=UKor8dtc22.so
Sybase
SwitchFile= 
  /opt/mqsi/merant/lib/UKase18.so
or
SwitchFile= 
  /opt/mqsi/merant/lib/UKasedtc20.so
or
SwitchFile=UKasedtc20.so
SwitchFile=UKasedtc22.so
Complete the following changes on HP-UX.
DBMS Change ... To ...
Oracle
SwitchFile= 
  /opt/mqsi/merant/lib/libSwitchOracle.sl
or
SwitchFile= 
  /opt/mqsi/merant/lib/UKor8dtc20.so
or
SwitchFile=UKor8tdc20.sl
SwitchFile=UKor8dtc22.sl
Sybase
SwitchFile= 
  /opt/mqsi/merant/lib/libSwitchSybase.sl
or
SwitchFile=
/opt/mqsi/merant/lib/UKase8dtc20.sl
or
SwitchFile=UKasedtc20.sl
SwitchFile=UKasedtc22.sl

Windows systems

To change the XA resource manager definitions on a Windows system:
  1. Open the Properties window of the broker queue manager using the WebSphere MQ Services snap-in.
  2. Open the Resources page.
  3. For each Oracle and Sybase database that participates in a global unit of work, coordinated by the broker queue manager, change the contents of the SwitchFile field. The following table specifies what you need to change for each database management system (DBMS).

    WBIMB represents the fully qualified path name of the directory in which you have installed WebSphere Message Broker.

DBMS Change ... To ...
Oracle WBIMB\bin\UKor8dtc18.dll or WBIMB\bin\UKor8dtc 20.dll WBIMB\bin\UKor8dtc22.dll
Sybase WBIMB\bin\UKase18.dll or WBIMB\bin\UKase20.dll WBIMB\bin\UKase22.dll
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:30:07

ah13850_ This topic's URL is: