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 <DB> db2 "create wrapper NET8 library 'libdb2net8.so'"