ConnectionTimeout IBM data server driver configuration keyword
Specifies the time in seconds to wait for a reply when an application tries to establish a connection to a server before the attempt is terminated.
- Equivalent db2cli.ini keyword
- ConnectTimeout
- Equivalent IBM® Data Server Provider for .NET connection string keyword
- Timeout
- db2dsdriver.cfg configuration syntax
<parameter name="ConnectionTimeout" value="0 | 1 |2 | ... | 32767"/>- Default setting:
- The client waits indefinitely for a reply from the server when an application tries to establish a connection.
- Equivalent connection attribute:
- SQL_ATTR_LOGIN_TIMEOUT
- Usage notes:
One second is the smallest interval for checking the timeout value. Therefore, the timeout event can take up to an additional second after the set timeout value.
If both the tcpipConnectTimeout and ConnectionTimeout values are set, the tcpipConnectTimeout keyword value should be less than the ConnectionTimeout keyword value.
The ConnectionTimeout keyword setting takes precedence over the tcpipConnectTimeout, MemberConnectTimeout, and MaxTransportWaittime keyword settings.
The connect timeout value is enforced for a connection, when a high availability solution is enabled. If a connection attempt fails within the time that is specified by the ConnectionTimeout value, control is returned to the application with an SQL30081N error. The error and control is returned whether all alternative servers are tried or not. In order to timeout socket connections to individual alternate servers, use tcpipConnectTimeout.
The ConnectionTimeout keyword applies only to the TCPIP protocol and is not supported for connections to databases cataloged on a SOCKS-enabled TCP/IP node.
The ConnectionTimeout keyword is available for use with embedded SQL applications.