DB2 Connection Issue
Posted: Tue Sep 12, 2006 4:00 am
Hello,
I need help on DB2 client connectivity from Datastage.
I am using DB2_UDB_API_0 stage to pull the data from a DB2 table. I have DB2 client on my local system. I am able to access DB2 through Command Window. But from my local machine i could not. Even some jobs(with the same stage designed at onsite) are able to run the jobs as well. Do i need to configure any thing at my local machinee?
Here is the issue.
Cust_Test..DB2_UDB_API_0: [IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009
Unable to connect to DB2 server '204.153.86.92'
Please guide me how resolve this issue.
Thanks & Regards,
iamnagus
I need help on DB2 client connectivity from Datastage.
I am using DB2_UDB_API_0 stage to pull the data from a DB2 table. I have DB2 client on my local system. I am able to access DB2 through Command Window. But from my local machine i could not. Even some jobs(with the same stage designed at onsite) are able to run the jobs as well. Do i need to configure any thing at my local machinee?
Here is the issue.
Cust_Test..DB2_UDB_API_0: [IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009
Unable to connect to DB2 server '204.153.86.92'
Please guide me how resolve this issue.
Thanks & Regards,
iamnagus