Before you migrate a broker, create ODBC definitions for databases that specify appropriate database drivers for IBM® Integration Bus Version 9.0.
The database drivers that are supported by IBM Integration Bus Version 9.0 might be at a later version than the drivers used by WebSphere® Message Broker Version 7.0 or WebSphere Message Broker Version 6.1.
Complete this update before you run the mqsimigratecomponents command for the broker that uses these ODBC connections.
Follow the instructions that are provided for your operating system:
The following table displays the name of the new ODBC driver for each database management system (DBMS).
DBMS | IBM Integration Bus Version 9.0 ODBC driver name |
---|---|
Oracle | IBM Integration Bus DataDirect Technologies 7.0 32-BIT Oracle Wire Protocol |
Sybase | IBM Integration Bus DataDirect Technologies 7.0 32-BIT Sybase Wire Protocol |
DBMS | Change ... | To ... |
---|---|---|
Oracle | WBIMB\bin\ukor8dtc22.dll or WBIMB\bin\ukor8dtc23.dllor WBIMB\bin\ukora24.dll |
WBIMB\bin\ukora26.dll |
Sybase | WBIMB\bin\ukase22.dll or WBIMB\bin\ukase23.dllor WBIMB\bin\ukase24.dll |
WBIMB\bin\ukase26.dll |
In the XAResourceManager stanza for each Oracle and Sybase database that participates in a global unit of work that is coordinated by the broker queue manager, change the entry for the switch file. For changes to the switch file configuration to take effect, you must restart the broker queue manager.
The following table specifies what you must change for each broker operating system and database management system (DBMS).
DBMS | Change ... | To ... |
---|---|---|
Oracle | SwitchFile=UKor8dtc22.so or SwitchFile=UKoradtc22.soor SwitchFile=UKor8dtc23.soor SwitchFile=UKoradtc23.soor SwitchFile=UKoradtc24.so |
SwitchFile=UKoradtc26.so |
Sybase (not supported on Linux on IBM z Systems) | SwitchFile=UKasedtc22.so or SwitchFile=UKasedtc23.soor SwitchFile=UKasedtc24.so |
SwitchFile=UKasedtc26.so |
To check that your ODBC environment is set up correctly on Linux and UNIX systems, run the mqsicvp command. This command also validates the connection to all data sources that are listed in the odbc.ini file that are associated with a broker by using the mqsisetdbparms command. For more information, see mqsicvp command.
If you revert to a previous version of IBM Integration Bus, you must reverse the changes that you make to the ODBC definitions. Update your ODBC files after you run the mqsimigratecomponents command, but before you restart the broker at the earlier version.