Table of Contents

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