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