db2_federation

DB2 Federation configuration

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

  • db2_federation.txt
  • Last modified: 2019/10/18 20:04
  • by 127.0.0.1