Page 1 of 1
Not able to connect to DB2 database
Posted: Tue Jan 11, 2011 6:22 am
by Abhi700
When i am executing the job i got this error.
"DB2_UDB_Enterprise_68: The file `/home/iSpi0h00/sqllib/db2nodes.cfg' must exist and be readable by all users!"
The db2nodes.cfg is existed & it is in read only mode.
Thanks in Advance.
Posted: Tue Jan 11, 2011 3:13 pm
by ray.wurlod
Where is it, and is that findable by the user who executes DataStage job? (For example, what is the relationship between the location of db2nodes.cfg and the value of DB2INSTANCE or APT_DFLT_DBNAME?)
Posted: Wed Jan 12, 2011 2:05 am
by Abhi700
I had replaced the DB2Instance Name at the Admin Level.
Now i am facing different error the error is " Unable to connect to DB2 server 's456bp320'.
I am able to load Columns from plug in meta data.
I am able to connnect to DB2Control center and check the tables.
But when i am executing datastage job i got the below error.
"DB2_UDB_API_70,0: Fatal Error: Fatal: SQLExecDirect: DB2 error info message '[IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009'.
DSTAGE-DB2CLI-0005`:`Unable to connect to DB2 server 's456bp320'. "
Thanks in Advance.