DB2 Version 10.1 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 complete before a 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 configuration keyword to specify the amount of time, in seconds, that a client waits for a query execution to time out before attempting to cancel the execution and return control to the application.

Start of change If the QueryTimeout keyword value is set to 0, the query timeout value that is set by the application is ignored and query is allowed to run until it is completed. End of change

Start of change The query timeout does not affect the XA control operations. The XA control operations include operations such as xa_open, xa_prepare, and others. End of change

Starting in DB2® V10.1 Fix Pack 2 and later, embedded SQL applications support the QueryTimeout keyword that is specified in the IBM data server driver configuration file (db2dsdriver.cfg).

Application can achieve different QueryTimeout behavior across different database connections by having different values in the IBM data server driver configuration file (db2dsdriver.cfg).

The interruptProcessingMode keyword setting affects the behavior of theQueryTimeout keyword.

Start of change 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. End of change