Tuesday, November 10, 2009

DSDB2 Import (Unable to obtain list of available DB2 Servers)

Reason - This is dsenv set up issue. PATH variable is not correctly defined.

Resolution -

The previous entry for DB2

###############################################################
# DB2 Setup
###############################################################
DB2DIR=/opt/ibm/db2/V9.5; export DB2DIR
DB2INSTANCE=db2clt9; export DB2INSTANCE
INSTHOME=/db2/db2clt9; export INSTHOME
PATH=$PATH:$DB2DIR/bin; export PATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$DB2DIR/lib32:$INSTHOME/sqllib/lib; export LD_LIBRARY_PATH

Suggested change:

PATH=$PATH:$DB2DIR/bin:$INSTHOME/sqllib/bin:$INSTHOME/sqllib/adm; export PATH

Save and run dsenv. Restart the services in order to reflect the PATH variable as updated.

No comments:

Post a Comment