DSXchange

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.

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

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