Error Reading from Db2 database using Db2 API stage.
Posted: Thu Jan 11, 2007 4:29 pm
Hi,
I am facing problem when I try to execute a job to read from db2 database using Db2 API stage. Connection to Db2 Database is fine we are able to perform view data.
We have problem when we tried to execute job with All the details in Db2 API stage passed as Environment variables.
When we mention all required options (server name, db name, user name,password) in Db2 API stage with Environment variables I am able to perform "view data" successfully but not able to execute the job successfully.
However if I hardocde the details in Db2 API stage job runs just fine.
This is the error I get in the log. (I checked the log to made sure correct Env parameter values are passed to the job. )
APT_CombinedOperatorController,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009
Unable to connect to DB2 server '#DSCAPIOP__DB2DSN#'.
Also, all other stages including Db2 Enterprise stage (connecting to same databse) works fine with Environment variables.
Is that some setting we need to do from server side?
Thanks
I am facing problem when I try to execute a job to read from db2 database using Db2 API stage. Connection to Db2 Database is fine we are able to perform view data.
We have problem when we tried to execute job with All the details in Db2 API stage passed as Environment variables.
When we mention all required options (server name, db name, user name,password) in Db2 API stage with Environment variables I am able to perform "view data" successfully but not able to execute the job successfully.
However if I hardocde the details in Db2 API stage job runs just fine.
This is the error I get in the log. (I checked the log to made sure correct Env parameter values are passed to the job. )
APT_CombinedOperatorController,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009
Unable to connect to DB2 server '#DSCAPIOP__DB2DSN#'.
Also, all other stages including Db2 Enterprise stage (connecting to same databse) works fine with Environment variables.
Is that some setting we need to do from server side?
Thanks