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.
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. Follow the instructions provided in Changing the XA resource manager definitions on Linux and UNIX systems.
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. Follow the instructions provided in Changing the XA resource manager definitions on Windows systems.
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.
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).
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
orSwitchFile=
/usr/opt/mqsi/merant/lib/UKase18.so
|
SwitchFile=
install_dir/merant/lib/UKase20.so
|
DBMS | Change ... | To ... |
---|---|---|
Oracle | SwitchFile=
/opt/mqsi/merant/lib/UKor8dtc16.so
orSwitchFile=
/opt/mqsi/merant/lib/UKor8dtc18.so
|
SwitchFile= install_dir/merant/lib/UKor8dtc20.so |
Sybase | SwitchFile=
/opt/mqsi/merant/lib/UKase16.so
orSwitchFile=
/opt/mqsi/merant/lib/UKase18.so
|
SwitchFile= install_dir/merant/lib/UKase20.so |
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 |
DBMS | New ODBC driver |
---|---|
Oracle | MQSeries® DataDirect Technologies 5.0 32-BIT Oracle |
Sybase | MQSeries DataDirect Technologies 5.0 32-BIT Sybase Wire Protocol |
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 |