Release Notes

6.4 Chapter 26. Accessing Oracle Data Sources

In addition to supporting wrappers on AIX and Windows NT, DB2 Universal Database now supports the Oracle wrapper on Linux, the Solaris Operating Environment, and HP-UX. This support is limited to Oracle Version 8. To access the wrappers for these platforms, you need to insert the V7.2 DB2 Relational Connect CD and select Distributed Join for Oracle data sources.

Once you have installed DB2 Relational Connect, you can add an Oracle data source to a federated server:

1. Install and configure the Oracle client software on the DB2 federated server.
2. For DB2 federated servers on UNIX, run the djxlink script to link-edit Oracle SQL*Net or Net8 libraries to your DB2 federated server and create the DB2 federated wrapper library for use with Oracle.
3. Create (or update) the db2dj.ini file to add environment variables for Oracle. This file must contain a definition for the ORACLE_HOME environment variable.
4. (Optional) Set the DB2_DJ_INI and the DB2_DJ_COMM profile registry variables.
5. Check the location and contents of the Oracle tnsnames.ora file on the DB2 federated server, and test the connections to the Oracle server using Oracle sqlplus.
6. Recycle the DB2 instance.
7. Create the wrapper.
8. Create a server definition.
9. Create a user mapping.
10. Test the configuration using Set Passthru.
11. Create nicknames for the tables and views.

Detailed instructions for these steps, including setting the environment variables, are in Chapter 26. Setting Up a Federated System to Access Oracle Data Sources in the DB2 Installation and Configuration Supplement. This information is also available online at http://www.ibm.com/software/data/db2/relconnect/.

6.4.1 Documentation Errors

The section, "Adding Oracle Data Sources to a Federated System" has the following errors:

• An additional step is needed between steps 2 and 3 in the book. The first three steps should be as follows:
  1. Install and configure the Oracle client software on the DB2 federated server using the documentation provided by Oracle.
  2. Set the ORACLE_HOME environment variable:

     export ORACLE_HOME=<oracle_home_directory>.
     

  3. For DB2 federated servers running on UNIX platforms, run the djxlink script to link-edit the Oracle SQL*Net or Net8 libraries to your DB2 federated server. Depending on your platform, the djxlink script is located in:

     /usr/lpp/db2_07_01/bin on AIX

     /opt/IBMdb2/V7.1/bin Solaris Operating Environment

     /opt/IBMdb2/V7.1/bin HP-UX

     /usr/IBMdb2/V7.1/bin Linux

     Run the djxlink script only after installing Oracle's client software on the DB2 federated server.

  4. Set data source environment variables by modifying the db2dj.ini file and issuing the db2set command. The db2set command updates the DB2 profile registry with your settings.

     Detailed instructions for setting the environment variables are in Chapter 26. Setting Up a Federated System to Access Oracle Data Sources of the DB2 Installation and Configuration Supplement.

  5. Continue the steps from step 3 as written in the book.
• The documentation indicates to set:

  DB2_DJ_INI = sqllib/cfg/db2dj.ini
  

  This is incorrect, it should be set to the following:

  DB2_DJ_INI = $INSTHOME/sqllib/cfg/db2dj.ini