QueryTimeout IBM data server driver configuration keyword
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
- Equivalent IBM® Data Server Provider for .NET connection string keyword
- IBM data server driver configuration file (db2dsdriver.cfg) syntax
<parameter name="QueryTimeout" value="0 | positive_integer"/>
- Default setting:
- 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
- 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.