Page 1 of 1

Not able to connect to DB2 database

Posted: Fri Jan 07, 2011 12:21 am
by skyboyfli
Hi,

Our DB2 database is recently created.
When we are trying to import metadata is giving error like
Database connect options: dbname= 'DBRE2323K', server='s3434w33', dboptions='{user='XXXXxX',password='XXXXXXX'}'Failed to connect to the database
##E IIS-DSEE-TCDU-00063 22:17:06(006) <main_program> Failed to connect to the database.

I am able to acess all tables in DB2 database. But not identifing the server in datastage designer.
Is there anything needed to be done in DSEnv file.
or any configurations required for newly created database.

Thanks in Advance.

Posted: Fri Jan 07, 2011 12:39 am
by ray.wurlod
Is DB2 client software correctly installed and configured on your DataStage server? If you are expecting parallel operation, you may also need to configure db2nodes.cfg. More information can be had from the Configuration Guide for DB2 Connectivity, one of the manuals in the standard documentation set.

Posted: Fri Jan 07, 2011 12:48 am
by skyboyfli
Thanks for your early reply..
the configurations are not done in my datastage server

how to configure db2nodes.cfg and where can i find it in the server