db2_federation [My wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== DB2 Federation configuration ======

===== Oracle data source =====

==== Configure Oracle local net service in Client ====

==== Setup federation in DB2 ====

**1. Enable instance for federation :**
<sxh bash>
db2 update dbm cfg using federated yes
</sxh>

**2. Create or edit ~/sqllib/cfg/db2dj.ini to point to ORACLE_HOME of Oracle client :**
<sxh bash>
ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/client_1
</sxh>

**3. Edit DB2 user's profile to export ORACLE_HOME and DB2LIBPATH :**
<sxh bash>
export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/client_1
export DB2LIBPATH=$ORACLE_HOME/lib:$DB2LIBPATH:$DB2LIB
</sxh>

**4. Reload the profile and bounce the instance :**
<sxh bash>
. ~/.bashrc or ~/.profile

db2stop
db2start
</sxh>

**5. Create the Oracle predefined NET8 wrapper :**
<sxh bash>
db2 connect to <DB>
db2 "create wrapper NET8 library 'libdb2net8.so'"
</sxh>