Unable to connect to UDB Db2 on Unix

nvuradi · Post by **nvuradi** » Tue Jun 24, 2008 9:40 pm

Hi ,

When I am trying to connect to db2 Udb on UNIX, I am getting the following error.

05:30:17(000) <DB2_UDB_Enterprise_0> The getpwnam() function failed for the DB2INSTANCE environment variable

this is the first time i am trying to connect to this database from my datastage.

also i have checked for the variables in dsenv file

DB2DIR
DB2INSTANCE
INSTHOME
LD_LIBRARY_PATH1
THREADS_FLAG

and they are set.

can anyone help me solving this issue?

appreciate your help.

thanks,
Naren

vmcburney · Post by **vmcburney** » Tue Jun 24, 2008 10:34 pm

Connecting to DB2 is a pain. Have a look at the IBM developerworks article Configure DB2 remote connectivity with WebSphere DataStage Enterprise Edition.