ODBC--call failed. SQL0666 - Estimated processing time exceeds li

[Guest]

I wrote some queries that pull information from a database that is set up on
a server. When the queries are run, the following error message is returned:
ODBC--call failed.
[IBM][Client Access Express ODBC Driver(32-bit)][DB2/400 SQL]SQL0666 -
Estimated query processing time 218 exceeds limit 60. (#-666)

I believe that this error means the time that Access estimates this query
will take to run (218 seconds...whether it actually will take this long or
not) is greater than the allowable time set in the system (60 seconds). I
was wondering if anyone knew either how to change the limit set in the system
to a higher limit or how I might be able to get my query to run faster?

I appreciate any information that anyone might have.

Thanks!

 

[Wolfgang Kais]

Hello Samir.

I wrote some queries that pull information from a database that is
set up on a server. When the queries are run, the following error
message is returned:
ODBC--call failed.
[IBM][Client Access Express ODBC Driver(32-bit)][DB2/400 SQL]
SQL0666 -
Estimated query processing time 218 exceeds limit 60. (#-666)

I believe that this error means the time that Access estimates this
query will take to run (218 seconds...whether it actually will take
this long or not) is greater than the allowable time set in the
system (60 seconds). I was wondering if anyone knew either how to
change the limit set in the system to a higher limit or how I might be
able to get my query to run faster?

You better post this message in a DB2 newsgroup, or contact your database
admin. It's not Access that estimates the query costs, it's the server.
To make the query run faster... one needs more information.