Updating ODBC definitions when you migrate to IBM Integration Bus Version 10.0

The database drivers that are supported by IBM Integration Bus Version 10.0 might be at a later version than the drivers used by previous versions.

Complete this update before you run the mqsimigratecomponents command for the integration node that uses these ODBC connections.

Follow the instructions that are provided for your operating system:

Windows systems

Change the ODBC connection definitions:

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 integration node, compare the ODBC driver against the entries that are listed in the following table. If the ODBC driver does not match, you need to associate the data source name with the new ODBC driver by using the following instructions:
   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).

   DBMS	IBM Integration Bus Version 10.0 ODBC driver name
   Sybase	IBM Integration Bus 10.0.0.n - DataDirect Technologies 64-BIT Sybase Wire Protocol
   Oracle	IBM Integration Bus 10.0.0.n - DataDirect Technologies 64-BIT Oracle Wire Protocol

   where n is the level of the installed fix pack.

Change the XA resource manager definitions:

1. Open the Properties window of the integration node queue manager by 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 that is coordinated by the integration node queue manager, change the contents of the SwitchFile field. For changes to the switch file configuration to take effect, you must restart the integration node queue manager.
   The following table specifies the entries you must change for each database management system (DBMS). install_dir represents the fully qualified path name of the directory in which you installed IBM Integration Bus.

   DBMS	Original entry	New entry
   Oracle	install_dir\server\bin\ukor8dtc22.dll or install_dir\server\bin\ukor8dtc23.dll or install_dir\server\bin\ukora24.dll or install_dir\server\bin\ukora26.dll	WBIMB\bin\ukora95.dll
   Sybase	install_dir\server\bin\ukase22.dll or install_dir\server\bin\ukase23.dll or install_dir\server\bin\ukase24.dll or install_dir\server\bin\ukora26.dll	WBIMB\bin\ukase95.dll

Linux® and UNIX systems

Change the ODBC connection definitions:

Create an ODBC definitions file by following the instructions in Connecting to a database from Linux and UNIX systems by using the IBM Integration ODBC Database Extender. Before you run the commands at the new service level, check that your ODBCINI environment variable points to the new file and not to the existing file. Check that ODBCSYSINI environment variable is set to point to the directory that contains your odbcinst.ini file.

Change the XA resource manager definitions:

To change the XA resource manager definitions, edit the queue manager configuration file (qm.ini) of the queue manager that is associated with the integration node. The qm.ini file is in the directory /var/mqm/qmgrs/queue_manager_name, where queue_manager_name is the name of the queue manager that is associated with the integration node.

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.so or SwitchFile=UKor8dtc23.so or SwitchFile=UKoradtc23.so or SwitchFile=UKoradtc24.so or SwitchFile=UKoradtc26.so	SwitchFile=UKoradtc95.so
Sybase (not supported on Linux on Z)	SwitchFile=UKasedtc22.so or SwitchFile=UKasedtc23.so or SwitchFile=UKasedtc24.so or SwitchFile=UKoradtc26.so	SwitchFile=UKasedtc95.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 an integration node by using the mqsisetdbparms command. For more information, see mqsicvp command.