Before you migrate an integration node, create ODBC definitions for databases
and specify appropriate database drivers for IBM® Integration Bus Version 10.0.
About this task
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:
-
- Open the ODBC Data Source
Administrator window.
- Open the System DSN page.
- 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:
- Delete the data source by clicking Remove.
- 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:
-
- Open the Properties window of the integration node queue
manager by using the WebSphere® MQ Services snap-in.
- Open the Resources page.
- 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.
Results
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 integration node at the earlier version.