IBM Integration Bus, Version 9.0.0.8 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS

See information about the latest product version

Configuring the IBM Integration ODBC Database Extender

IBM® Integration ODBC Database Extender encapsulates the unixODBC driver manager, which is an implementation of the Open DataBase Connectivity interface for UNIX systems, and this topic describes how you configure it.

Before you start:

Install the IBM Integration ODBC Database Extender.

To allow IBM Integration Bus to take advantage of the additional database support, it needs to know where you have installed the SupportPac. The location of the SupportPac needs to be set by the value of the environment variable IE02_PATH.

This environment variable is automatically set within the IBM Integration Bus profile during the installation of the SupportPac, by the creation of a script. The script name contains the pattern IE02 and is placed within the directory /var/mqsi/common/profiles. See the following example file:

#!/usr/bin/sh
# This file was created as part of the IBM Integration Bus ODBC
# Database Extender SupportPac install
export IE02_PATH=/opt/ibm/IE02/2.0.1

If you alter the location of your $MQSI_WORKPATH and, therefore, alter the location where IBM Integration Bus dynamically runs additional scripts while loading its profile, you must either copy the existing file, or create a new file containing the required contents within your new ${MQSI_WORKPATH}/common/profiles directory.

You must not put the lib directory of the IBM Integration ODBC Database Extender into your library path (LD_LIBRARY_PATH or equivalent). If you do so, the IBM Integration ODBC Database Extender is not correctly loaded by IBM Integration Bus and unpredictable results can occur.

Configure the database that you are going to use; see Connecting to a database from Linux and UNIX systems by using the IBM Integration ODBC Database Extender

bh13425_.htm |

Last updated Friday, 21 July 2017