How do we set the DB2DIR variable?

Salegueule · Post by **Salegueule** » Thu Sep 10, 2009 9:48 am

Having connectivity problem with DB2 after migrating to V9. In Director I see that we are still poinitng to DB2 V8. The DB2DIR variable do not seems to be iclude in the DS Administrator Environment panels.

Curently we have DB2DIR=/usr/opt/db2_08_01

Where do we set this variable? Besides the path ,does any other variable needs to be change after a DB2 upgrade?

Thanks.

ArndW · Post by **ArndW** » Thu Sep 10, 2009 9:52 am

Have you checked the "dsenv" file, it is set there or it calls a DB2 script which might set it.

dunquach · Post by **dunquach** » Fri Sep 11, 2009 4:59 am

Set this in dvenv file :

DB2DIR=/opt/ibm/db2;export DB2DIR
DB2INSTANCE=db2inst1;export DB2INSTANCE INSTHOME=/home/db2inst1;export INSTHOME PATH=$PATH:$INSTHOME/sqllib/bin:$INSTHOME/sqllib/adm:$INSTHOME/sqllib/misc
export PATH

Then restart the DataStage server with the following command under $DSHOME/DSEngine:
. ./dsenv
bin/uv -admin -stop
bin/uv -admin -start