Before you migrate an integration server or integration node, create ODBC definitions for databases and specify appropriate database drivers for IBM® App Connect Enterprise Version 11.0.
The database drivers that are supported by IBM App Connect Enterprise Version 11.0 might be at a later version than the drivers used by previous versions.
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 App Connect Enterprise Version 11.0 ODBC driver name |
---|---|
Sybase | IBM App Connect Enterprise 11.0.0.n - DataDirect Technologies 64-BIT Sybase Wire Protocol |
Oracle | IBM App Connect Enterprise 11.0.0.n - DataDirect Technologies 64-BIT Oracle Wire Protocol |
DBMS | Original entry | New entry |
---|---|---|
Oracle | install_dir\server\bin\ukor8dtc22.dll or install_dir\server\bin\ukor8dtc23.dllor install_dir\server\bin\ukora24.dllor install_dir\server\bin\ukora26.dll |
WBIMB\bin\ukora95.dll |
Sybase | install_dir\server\bin\ukase22.dll or install_dir\server\bin\ukase23.dllor install_dir\server\bin\ukase24.dllor install_dir\server\bin\ukase26.dll |
WBIMB\bin\ukase95.dll |
In the XAResourceManager stanza for each Oracle and Sybase database that participates in a global unit of work that is coordinated by the integration node queue manager, change the entry for the switch file. For changes to the switch file configuration to take effect, you must restart the integration node queue manager.
The following table specifies the entries that you must change for each operating system and database management system (DBMS).
DBMS | Original entry | New entry |
---|---|---|
Oracle | SwitchFile=UKor8dtc22.so or SwitchFile=UKoradtc22.soor SwitchFile=UKor8dtc23.soor SwitchFile=UKoradtc23.soor SwitchFile=UKoradtc24.soor SwitchFile=UKoradtc26.so |
SwitchFile=UKoradtc95.so |
Sybase (not supported on Linux on IBM z Systems®) | SwitchFile=UKasedtc22.so or SwitchFile=UKasedtc23.soor SwitchFile=UKasedtc24.soor SwitchFile=UKasedtc26.so |
SwitchFile=UKasedtc95.so |