How to connect Cognos 10.2 with DB2 v9.7 data source on AIX?

person sticking a post it on a white board with the words how to written on it

To access DB2 remote database data source in Cognos you have to do following things on Cognos machine.

  1. Install DB2 client
  2. Set DB2 envoirnment variables
  3. Catalog remote host and database

After above these steps, add a new DB2 data source in Cognos Configurations. Navigate to IBM Cognos Connection > Launch > IBM Cognos Administration > Configuration and click New Data Source.

I set following environment variables in /etc/profile.

 JAVA_HOME=/usr/java6_64/jre
 PATH=$JAVA_HOME/bin:$PATH:/u01/ibm_cognos/cognos/c10_64/bin:/u01/IBM/db2/V9.7/bin
 LIBPATH=/u01/ibm_cognos/cognos/c10_64/bin:/home/db2inst1/sqllib/lib32
 export JAVA_HOME
 export PATH
 export LIBPATH

DB2DIR=/u01/IBM/db2/V9.7
 export DB2DIR

INSTHOME=/home/db2inst1
 export INSTHOME

DB2INSTANCE=db2inst1
 export DB2INSTANCE

You May Also Like

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.