Ask the Expert

Error on the Web server when using ODBC

Error on the Web server when using ODBC

We have a Web server using ODBC for starting SQL request on our iSeries. I now have an error on the ASP page using a SELECT: [IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL0666 -- Estimated query processing time 30 exceeds limit 30. Which parameter should I increase on OS/400 to fix this problem?
The Query Time Limit can be set a job or system level using the CHGQRYA command or the QQRYTIMLMT system value. You should first check to see if either of those are being done on the iSeries system. If the time limit is not set in that manner, then you can consider using the ODBC SQLSetConnectionOption or SQLSetStmtOption to set SQL_QUERY_TIMEOUT to 0. Another option on V5R2 & V5R3 systems is modifying the ODBC data source - on the performance tab, select the advanced button and deselect the query timeout attribute.

More details can be found in the Knowledge Base document #21130903.


Check out this Featured Topic: Database issues resolved's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: Tips, tutorials and more.

This was first published in August 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: