WebSphere Message Broker, Version 8.0.0.7 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS

See information about the latest product version

Switching WebSphere Message Broker to use the DataDirect V7 drivers

WebSphere® Message Broker Version 8.0 ships with the DataDirect V6.0 ODBC drivers. From Fix Pack Version 8.0.0.2 onwards, the DataDirect V7.0 ODBC drivers are shipped in addition to the V6.0 ODBC drivers on all supported platforms. From Fix Pack Version 8.0.0.6 onwards, the DataDirect V7.0 ODBC drivers are replaced by the V7.1 ODBC drivers on all supported platforms.

The V6.0 drivers remain as the default. If you want to switch to using the V7.x drivers, some manual reconfiguration is required:

Windows
On the Windows platform, the following additional ODBC drivers are available to configure as an ODBC data source Name:
32-bit
  • WebSphere Message Broker (8.0.0.x) DataDirect Technologies 7.x 32-BIT Oracle Wire Protocol
  • WebSphere Message Broker (8.0.0.x) DataDirect Technologies 7.x 32-BIT Sybase Wire Protocol
64-bit
  • WebSphere Message Broker (8.0.0.x) DataDirect Technologies 7.x 64-BIT Oracle Wire Protocol
  • WebSphere Message Broker (8.0.0.x) DataDirect Technologies 7.x 64-BIT Sybase Wire Protocol
Configure these V7.x drivers in the same way as for the default V6.0 drivers, for more information, see Connecting to a database from Windows systems.

Linux and UNIX
On these platforms, the DataDirect V7.x drivers are installed in:
<Your Broker install directory>/ODBC/V7.0

In your environment, you must add the path to the DataDirect V7.x libraries to the front of the library search path that is defined with the LD_LIBRARY_PATH or LIBPATH environment variable. To achieve this, copy the <Your Broker install directory>/ODBC/V7.0/DDV7librarypath.sh file to either your $MQSI_WORKPATH/common/profiles directory if you want all your brokers to use it, or to $MQSI_WORKPATH/config/<Your Broker name>/profiles directory for a specific broker to use.

Use the following steps to create a new odbc.ini file to use the DataDirect Version 7.x drivers:

  1. Stop any brokers that are running on the computer.
  2. Make a copy of your current $ODBCINI file.
  3. Make a copy of the DataDirect V7.0 template odbc.ini file that is located at:

    <Your Broker install directory>/ODBC/unixodbc/odbcV7.ini.

  4. Update your copy of the V7 template file as follows:
    1. Edit the final stanza in the odbc.ini file, the [ODBC] stanza, to specify the location of the installed DataDirect V7.x ODBC drivers.
    2. Edit the first stanza in the odbc.ini file, the [ODBC Data Sources] stanza, to list the DSN of each database that the broker is going to use. The list will probably be the same as the list in the original $ODBCINI file.
    3. Create a DSN stanza for each data source that is listed in the [ODBC Data Sources] stanza. The configuration information for each DSN may be based on the information from the original $ODBCINI file.
  5. Ensure that your $ODBCINI environment variable points to this new odbc.ini file.
  6. Restart the brokers.

XA Coordination
If you use Global (XA) coordination with WebSphere Message Broker these additional instructions are also required.
Oracle on Windows
Specify <Your Broker install directory>\bin\UKoradtc26.dll as the SwitchFile, otherwise follow the configuration steps for Windows documented in Configuring global coordination with Oracle
Linux and UNIX
These additional steps are also required:
  1. Stop any running brokers that are using XA coordination.
  2. Stop any WebSphere MQ queue managers that are used to manage XA coordination with the brokers.
  3. For each queue manager that is coordinating global transactions, update its qm.ini file by changing all the SwitchFile entries:
    1. For Oracle, change it to UKoradtc26.so.
    2. For Sybase, change it to UKasedtc26.so.
  4. Become the root user and use the mqsimanagexalinks command to:
    1. Remove the links that are required for XA coordination by the previous version of the DataDirect drivers:
      mqsimanagexalinks remove DDnn
      where DDnn is the version number of the DataDirect drivers you previously used, for example DD60.
    2. Create the links that are required for XA coordination with the DataDirect V7 drivers:
      mqsimanagexalinks create DD71 <Your Broker install directory> <Your $IE02_PATH>
    3. For full details of the mqsimanagexalinks command, see mqsimanagexalinks command - Linux and UNIX systems
  5. Restart the WebSphere MQ queue managers.
  6. Restart the brokers.

Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2016Copyright IBM Corporation 1999, 2016.

        
        Last updated:
        
        Last updated: 2016-05-23 14:47:08


Task topicTask topic | Version 8.0.0.7 | ah58340_