topic DB2 - SQL0666 SQL query exceeds specified time limit or storage limit in Qlik Replicate

DB2 - SQL0666 SQL query exceeds specified time limit or storage limit

ThiebaudS — Fri, 14 Aug 2020 08:26:09 GMT

Hi there,

I currently have an issue with a replicate task (DB2 for iSeries to SQL Server), returning the following error:

sql0666 sql query exceeds specified time limit or storage limit

In DB2 I have the "QQRYTIMLMT" set to "*NOMAX".

Everything that I've found relating to this error, says to adjust some settings in the ODBC data source, but I don't have anything listed in ODBC data source administrator > system DSN.

Other tasks using the same endpoints, but different tables are working great.

If anyone has some tip, I would appreciate it.

Thanks a lot.

Best regards,

Re: DB2 - SQL0666 SQL query exceeds specified time limit or storage limit

john_wang — Fri, 14 Aug 2020 08:44:06 GMT

There are many reasons may lead this error, you can try something:

1. You can see in user guide the limitation "Row size cannot exceed 32740 bytes". Check your row size.

2. Set internal parameter "executeTimeout" to a reasonable long time (depend on how long you got the error) in the source endpoint

3. create a ODBC DSN manaually and Turn off the checkmark in the Allow Query Timeout checkbox

and then use the ODBC DSN in source endpoint. Some helpful links

http://vijirajkumar.blogspot.com/2009/12/error-hy000-ibmiseries-access-odbc.html

https://www.ibm.com/support/pages/node/641523

Try that and let us know if it's helpful.

Re: DB2 - SQL0666 SQL query exceeds specified time limit or storage limit

ThiebaudS — Fri, 14 Aug 2020 10:53:54 GMT

Thanks a lot @john_wang

I will check and try that.

BR,

Re: DB2 - SQL0666 SQL query exceeds specified time limit or storage limit

Bill_Steinagle — Fri, 11 Nov 2022 13:12:11 GMT

Hi,

Thank you for the post to the QDI Forums. I would have the DB2i DBA check the QZDASOINIT Initialization job that starts on the DB2i Source to see if there is a failure on the Source side too. The INIT job is for the SQL and ODBC connection to the DB along with John's suggestion on the ODBC client. Hope this helps and please post if the information provided helped with the post.

Thanks!

Bill

Re: DB2 - SQL0666 SQL query exceeds specified time limit or storage limit

harsh2 — Tue, 07 Nov 2023 14:00:04 GMT

Hi john,

error : "SQL query exceeds specified limit or threshold. Failed (retcode -1) to execute statement"

Source : IBM DB2 for iseries

Task : Logstream Task

so ,

Settings are applied as per this http://vijirajkumar.blogspot.com/2009/12/error-hy000-ibmiseries-access-odbc.html doc for query timeout then it should be error for to many selection of tables in one task ?

Thanks,

Harsh Patel