DB2 graphic  QMF Version 8

Timeouts

You use the Timeouts page to set timeout warning and cancellation limits for idle queries, idle connections, and server response time.

Table 18. Resource Limits Timeout Fields
Field Description
Idle Query Timeouts This value limits the amount of time a query can remain idle. You can set two different timeouts:
  • Warning Limit: When this timeout expires, QMF for Windows reminds the user that the query is idle and prompts the user asking if the query should be canceled.
  • Cancel Limit: When this timeout expires, QMF for Windows cancels the query automatically.
Note:
A query might be idle when the first buffer of data has been returned to the user and QMF for Windows is waiting for that user to go to the bottom of the data before it fetches the next set of data.
Server Response Timeouts This value limits the amount of time QMF for Windows waits for a response from the database server before canceling a request. QMF for Windows waits asynchronously for a response time each time it sends a request to the database server.

You can set two different timeouts:

  • Warning Limit: When this timeout expires, QMF for Windows prompts the user asking if the query should be canceled.
  • Cancel Limit: When this timeout expires, QMF for Windows cancels the request automatically.
Note:
A lower timeout limit prevents long-running (runaway) queries. A higher timeout limit allows database requests to complete when the server is slow due to resource contention or other reasons.
Idle Connection Timeout Cancel Limit Limits the amount of time QMF for Windows retains an idle connection to the database server. When this timeout expires, QMF for Windows closes the idle connection to the database server automatically.
Note:
A lower timeout limit helps minimize the resources consumed at servers by idle connections. A higher timeout helps minimize the overhead of establishing connections.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004