Query Controller error

dspxguy · Post by **dspxguy** » Fri Nov 30, 2007 12:30 pm

Hi,
Any insights on this error message?

DB2 Driver Embedded SQL message: SQL29007N  Unable to communicate with the Query Controller.
;
sqlcode = -29007;
sqlstate =     
Failed to connect to database.
Error Idx = 9;
DB2 Driver Embedded SQL message: SQL29007N  Unable to communicate with the Query Controller.
;
sqlcode = -29007;
sqlstate =     
Open failed

Thanks

sud · Post by **sud** » Fri Nov 30, 2007 1:37 pm

Very apparent from the error message : "Failed to connect to database". First see if you are able to connect to database from the datastage server machine to your DB2 instance.

dspxguy · Post by **dspxguy** » Fri Nov 30, 2007 2:33 pm

yes i can connect to the database from ds server

ray.wurlod · Post by **ray.wurlod** » Fri Nov 30, 2007 6:58 pm

Use the DS_CONNECT command to test connectivity using the DataStage DSN for connection to this database. The DS_CONNECT command must be issued from within an interactive dssh session.

dspxguy · Post by **dspxguy** » Mon Dec 03, 2007 1:16 pm

yeah it is working, it was a dba issue.

DSXchange

Query Controller error

Query Controller error

Re: Query Controller error