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
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
- 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:
- Stop any brokers that are running on the computer.
- Make a copy of your current $ODBCINI file.
- Make a copy of the DataDirect V7.0 template odbc.ini file that is located at:
<Your Broker install directory>/ODBC/unixodbc/odbcV7.ini.
- Update your copy of the V7 template file as follows:
- Edit the final stanza in the odbc.ini file, the [ODBC] stanza, to specify the location of the installed DataDirect V7.x ODBC drivers.
- 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.
- 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.
- Ensure that your $ODBCINI environment variable points to this new odbc.ini file.
- 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:
- Stop any running brokers that are using XA coordination.
- Stop any WebSphere MQ queue managers that are used to manage XA coordination with the brokers.
- For each queue manager that is coordinating global transactions, update its qm.ini file by changing all the SwitchFile entries:
- For Oracle, change it to UKoradtc26.so.
- For Sybase, change it to UKasedtc26.so.
- Become the root user and use the mqsimanagexalinks command to:
- Remove the links that are required for XA coordination by the previous version of the DataDirect drivers:
where DDnn is the version number of the DataDirect drivers you previously used, for example DD60.mqsimanagexalinks remove DDnn
- Create the links that are required for XA coordination with the DataDirect V7 drivers:
mqsimanagexalinks create DD71 <Your Broker install directory> <Your $IE02_PATH>
- For full details of the mqsimanagexalinks command, see mqsimanagexalinks command - Linux and UNIX systems
- Remove the links that are required for XA coordination by the previous version of the DataDirect drivers:
- Restart the WebSphere MQ queue managers.
- Restart the brokers.