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.
How do we set the DB2DIR variable?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Fri May 21, 2004 4:22 pm
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
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