Changing the 32-bit ODBC connection and XA resource manager definitions for a broker migrated from Version 2.1 or Version 5.0 to Version 6.0

Update definitions for Oracle and Sybase databases.

WebSphere® Message Broker Version 6.0 includes later 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 the later versions of the ODBC drivers for Oracle and Sybase databases.

Make the required changes before you run the Version 6.0 mqsimigratecomponents command. If you are restoring 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 32-bit ODBC connection definitions on Linux and UNIX systems

Linux platformUNIX platform Create a new ODBC definitions file by following the instructions in Connecting to a database from Linux and UNIX systems. Do not change the existing definition file.

Before you run Version 6.0 commands, check that your ODBCINI environment variable points to the new definitions file and not to the existing file.

Changing the XA resource manager definitions on Linux and UNIX systems

Linux platformUNIX platform 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).

AIX platform Complete the following changes on AIX®.
DBMS Change ... To ...
Oracle
SwitchFile= 
  /usr/opt/mqsi/merant/lib/UKor8dtc16.so
or
SwitchFile= 
  /usr/opt/mqsi/merant/lib/UKor8dtc18.so
SwitchFile= 
  install_dir/merant/lib/UKor8dtc20.so
Sybase
SwitchFile= 
  /usr/opt/mqsi/merant/lib/UKase16.so
or
SwitchFile= 
  /usr/opt/mqsi/merant/lib/UKase18.so
SwitchFile= 
  install_dir/merant/lib/UKase20.so
Solaris platformLinux platform Complete the following changes on Solaris and Linux.
DBMS Change ... To ...
Oracle
SwitchFile= 
  /opt/mqsi/merant/lib/UKor8dtc16.so
or
SwitchFile= 
  /opt/mqsi/merant/lib/UKor8dtc18.so
SwitchFile= 
  install_dir/merant/lib/UKor8dtc20.so
Sybase
SwitchFile= 
  /opt/mqsi/merant/lib/UKase16.so
or
SwitchFile= 
  /opt/mqsi/merant/lib/UKase18.so
SwitchFile= 
  install_dir/merant/lib/UKase20.so
HP-UX platform Complete the following changes on HP-UX.
DBMS Change ... To ...
Oracle
SwitchFile= 
  /opt/mqsi/merant/lib/libSwitchOracle.sl
SwitchFile= 
	install_dir/merant/lib/UKor8dtc20.sl
Sybase
SwitchFile= 
  /opt/mqsi/merant/lib/libSwitchSybase.sl
SwitchFile= 
	install_dir/merant/lib/UKasedtc20.sl

Changing the 32-bit ODBC connection definitions on Windows systems

Windows platform 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).
Start of change
DBMS New ODBC driver
Oracle MQSeries® DataDirect Technologies 5.0 32-BIT Oracle
Sybase MQSeries DataDirect Technologies 5.0 32-BIT Sybase Wire Protocol
End of change

Changing the XA resource manager definitions on Windows systems

Windows platform 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, and WMQIB represents the fully qualified path name of the directory in which you originally installed WebSphere MQ Integrator Broker or WebSphere MQ Integrator.

DBMS Change ... To ...
Oracle WMBIB\bin\ukor8dtc16.dll or WMBIB\bin\ukor8dtc18.dll WBIMB\bin\ukor8dtc20.dll
Sybase WMBIB\bin\ukasedtc16.dll or WMBIB\bin\ukasedtc18.dll WBIMB\bin\ukase20.dll
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2009Copyright IBM Corporation 1999, 2009.
Last updated : 2009-01-07 15:22:01

ah13850_