Error Message?

[afs24]

What does this mean? My query seems fine? How do I troubleshoot or fix?

[IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL666 - Estimated query processing time 70 exceed limit 60 (#-666).

 

[Dugantrain]

I'm not sure if this is the solution, but assuming that this is a Pass-Through query, give this a try:
-Open the Query in Design View
-Open the query's Properties
-Does ODBC Timeout say 60? If so, set it either higher than 60 or set it to 0 so that there is no timeout at all.

 

[afs24]

that was it thanks.