====== DB2 Federation configuration ======
===== Oracle data source =====
==== Configure Oracle local net service in Client ====
==== Setup federation in DB2 ====
**1. Enable instance for federation :**
db2 update dbm cfg using federated yes
**2. Create or edit ~/sqllib/cfg/db2dj.ini to point to ORACLE_HOME of Oracle client :**
ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/client_1
**3. Edit DB2 user's profile to export ORACLE_HOME and DB2LIBPATH :**
export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/client_1
export DB2LIBPATH=$ORACLE_HOME/lib:$DB2LIBPATH:$DB2LIB
**4. Reload the profile and bounce the instance :**
. ~/.bashrc or ~/.profile
db2stop
db2start
**5. Create the Oracle predefined NET8 wrapper :**
db2 connect to
db2 "create wrapper NET8 library 'libdb2net8.so'"