====== 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'"