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. |