DB2 10.5 for Linux, UNIX, and Windows

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

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.