Implementing Siebel Business Applications on DB2 UDB for z/OS > Maintenance Considerations for z/OS > Dynamic SQL in the Siebel Application >

Long-Running Queries and the RLF Error Message

You can set the DB2 Resource Limit Facility (RLF) to cancel long-running queries. For more information on using RLF, refer to the appropriate IBM documentation.

When performing long-running queries, users might receive the following RLF error message:

An error has occurred executing a query. Query did not execute successfully because it exceeded the resource limits set on the database server.

Please simplify your query or report this problem to your systems administrator.

This error occurs when an SQL statement is canceled by the DB2 Governor, because it exceeds the resource limits set on the database server.

If this message results from the execution of a Query by Example (QBE), users can try to simplify the query, or contact their systems administrator and describe what they were doing in the application when the error occurred.