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.
MORE INFORMATION ON THIS TOPIC
Check out this Search400.com Featured Topic: Database issues resolved
Search400.com's targeted search engine: Get relevant information on DB2/400.
The Best Web Links: Tips, tutorials and more.
Dig Deeper on DB2 UDB (universal databases)
Related Q&A from Kent Milligan
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ... Continue Reading
When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC ... Continue Reading
When developing tables in a parent-child relationship, use a primary key and a foreign key along with a unique ID to make your database easier to ... Continue Reading