Specifies the amount of time, in seconds,
that a client waits for a query execution to be completed before the
client attempts to cancel the execution and return control to the
application.
- Equivalent CLI keyword
- N/A
- Equivalent IBM® Data Server
Provider for .NET connection string keyword
- QueryTimeout
- IBM data server driver configuration
file (db2dsdriver.cfg) syntax
<parameter name="QueryTimeout" value="0 | positive_integer"/>- Default setting:
- N/A
- Usage notes:
- You can use the QueryTimeout keyword to control
the query timeout value of CLI,
.NET, or embedded SQL applications.
If you set the QueryTimeout keyword
to 0, the query timeout value that the application
set is ignored, and the query runs until it is completed.
The query timeout value does not affect XA control operations,
which include operations such as xa_open and xa_prepare.
- The interruptProcessingMode keyword
setting determines the type of action that takes place when the query
timeout event is triggered.
In
IBM Data Server Provider for .NET, the
CommandTimeout property takes precedence over the
QueryTimeout keyword that is set in the connection string. The
QueryTimeout keyword that is set in the connection string takes precedence over
the QueryTimeout keyword that is set in the
db2dsdriver.cfg file.