Updating ODBC definitions when you migrate to IBM App Connect Enterprise 13.0

Before you migrate an integration server or integration node, create ODBC definitions for databases and specify appropriate database drivers for IBM® App Connect Enterprise 13.0.

About this task

The database drivers that are supported by IBM App Connect Enterprise 13.0 might be at a later version than the drivers that are used by previous versions.

Follow the instructions that are provided for your operating system:

Updating ODBC definitions on Windows systems

Procedure

  1. To change the ODBC connection definitions, open the ODBC Data Source Administrator window, then open the System DSN page.
  2. 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, where n is the level of the installed fix pack (if appropriate).
    DBMS IBM App Connect Enterprise 13.0 ODBC driver name
    Sybase IBM App Connect Enterprise 12.0.1.n - DataDirect Technologies 64-BIT Sybase Wire Protocol
    Oracle IBM App Connect Enterprise 12.0.1.n - DataDirect Technologies 64-BIT Oracle Wire Protocol
    If the ODBC driver does not match, associate the data source name with the new ODBC driver by completing the following steps.
    1. Delete the data source by clicking Remove.
    2. Re-create the data source with the new ODBC driver by clicking Add.
  3. To change the XA resource manager definitions, complete the following steps.
    1. Open the Properties window of the integration node queue manager by using the IBM 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.
      The following table specifies the entries that 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 App Connect Enterprise.
      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\ukase26.dll      		 WBIMB\bin\ukase95.dll
    4. For changes to the switch file configuration to take effect, restart the integration node queue manager.

Updating ODBC definitions on Linux systems

Procedure

  1. To change the ODBC connection definition, 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 the ODBCSYSINI environment variable is set to point to the directory that contains your odbcinst.ini file.

  2. 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.

    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=UKasedtc26.so    		 SwitchFile=UKasedtc95.so
  3. For changes to the switch file configuration to take effect, restart the integration node queue manager.