Release Notes
|
|
|
|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:
|
- |Install and configure the Oracle client software on the DB2 federated
|server.
- |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.
- |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.
- |(Optional) Set the DB2_DJ_INI and the DB2_DJ_COMM profile registry
|variables.
- |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.
- |Recycle the DB2 instance.
- |Create the wrapper.
- |Create a server definition.
- |Create a user mapping.
- |Test the configuration to the Oracle server using Set Passthru.
- |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/.
|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:
|
- |Install and configure the Oracle client software on the DB2 federated
|server using the documentation provided by Oracle.
- |Set the ORACLE_HOME environment variable:
|export ORACLE_HOME=<oracle_home_directory>.
- |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.
- |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.
- |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
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]