Update definitions for Oracle and Sybase databases.
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.
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.
DBMS | New ODBC driver |
---|---|
Oracle | MQSeries DataDirect Technologies 5.20 32-BIT Oracle |
Sybase | MQSeries DataDirect Technologies 5.20 32-BIT Sybase Wire Protocol |
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/UKor8dtc18.so
or SwitchFile=
/usr/opt/mqsi/merant/lib/UKor8dtc20.so
orSwitchFile=UKor8tdc20.so |
SwitchFile=UK0r8dtc22.so |
Sybase | SwitchFile=
/usr/opt/mqsi/merant/lib/UKase18.so
orSwitchFile=
/usr/opt/mqsi/merant/lib/UKasedtc20.so
orSwitchFile=UKasedtc20.so |
SwitchFile=UKasedtc22.so |
DBMS | Change ... | To ... |
---|---|---|
Oracle | SwitchFile=
/opt/mqsi/merant/lib/UKor8dtc18.so
orSwitchFile=
/opt/mqsi/merant/lib/UKor8dtc20.so
orSwitchFile=UKor8tdc20.soor SwitchFile=UKoradtc20.so |
SwitchFile=UKor8dtc22.so |
Sybase | SwitchFile=
/opt/mqsi/merant/lib/UKase18.so
orSwitchFile=
/opt/mqsi/merant/lib/UKasedtc20.so
orSwitchFile=UKasedtc20.so |
SwitchFile=UKasedtc22.so |
DBMS | Change ... | To ... |
---|---|---|
Oracle | SwitchFile= /opt/mqsi/merant/lib/libSwitchOracle.slor SwitchFile= /opt/mqsi/merant/lib/UKor8dtc20.soor SwitchFile=UKor8tdc20.sl |
SwitchFile=UKor8dtc22.sl |
Sybase | SwitchFile= /opt/mqsi/merant/lib/libSwitchSybase.slor SwitchFile= /opt/mqsi/merant/lib/UKase8dtc20.slor SwitchFile=UKasedtc20.sl |
SwitchFile=UKasedtc22.sl |
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 |