Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Sudden SQL query failures

We were recently testing an application against V5R2. A couple of external SQL queries -- running via Client Access ODBC, which had been OK -- suddenly started failing with error SQL0666 (SQL Timeout). I understand the reason for this is that the optimizer thinks it's going to take longer to execute the query than its default timeout period. I'm wondering if there was a change between OS/400 at V5R1 and V5R2 that triggered this?
In V5R2 a new SQL Query Engine (SQE) was delivered that includes new algorithms and methods for the query optimizer to use. To learn more about SQE, click here.


Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: tips, tutorials and more.

Check out this Search400.com Featured Topic: Database issues resolved

This was last published in February 2004

Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.



  • How do I size a UPS unit?

    Your data center UPS sizing needs are dependent on a variety of factors. Develop configurations and determine the estimated UPS ...

  • How to enhance FTP server security

    If you still use FTP servers in your organization, use IP address whitelists, login restrictions and data encryption -- and just ...

  • 3 ways to approach cloud bursting

    With different cloud bursting techniques and tools from Amazon, Zerto, VMware and Oracle, admins can bolster cloud connections ...