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.
Not able to connect to DB2 database
Moderators: chulett, rschirm, roy
Not able to connect to DB2 database
ABHILASH
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
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.
ABHILASH