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.
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.
The query timeout does not affect the XA control operations. The XA control operations include operations such as xa_open, xa_prepare, and others.
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).
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.