MemberConnectTimeout IBM data server driver configuration keyword

Specifies the number of seconds before an attempt to open a socket fails to a member that is listed in an alternate server or member list. This timeout value is used when dealing with a connection to members in the data sharing member list in the Sysplex setup or member list of a Db2 pureScale instance. MemberConnectTimeout applies to WLB enabled connections.

Equivalent CLI keyword

N/A

Equivalent IBM® data server provider for .NET connection string keyword

N/A

IBM data server driver configuration file (db2dsdriver.cfg) syntax

<parameter name="MemberConnectTimeout" value="0 | 1 |2 | ... | 32767"/>

Default setting:

None. If the MemberConnectTimeout keyword value is set to 0 or a negative value, the tcpipConnectTimeout keyword value is used.

For Db2 for z/OS servers, the default value is 1 second.

Equivalent connection attribute:

N/A

Usage notes:

The MemberConnectTimeout keyword is only available for use with the automatic client reroute (ACR) feature.

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.

The MemberConnectTimeout keyword is available to set the number of seconds before an attempt to open a socket fails for each member that is listed in a server list. The server list is associated with the Db2® data-sharing group or Db2 pureScale instance. The MemberConnectTimeout keyword is used for each open socket to a member in the member list. If an attempt to open a socket to all members in the list fails, the driver attempts to connect to the group IP address. The attempted connection to a group IP address is affected by the timeout setting that is specified in the tcpipConnecTimeout keyword.

The MemberConnectTimeout value overrides the tcpipConnectTimeout value.

This keyword is only valid for use with the Db2 data-sharing and Db2 pureScale® features. The MemberConnectTimeout keyword specifies the number of seconds before an attempt to open a socket fails for each member that is listed in the alternate server or member list. Use this timeout value to reduce the wait time between establishing a connection to each member in the data sharing member list in the Db2 data-sharing group and Db2 pureScale instance.

The MemberConnectTimeout keyword is available for use with embedded SQL applications.

The MemberConnectTimeout keyword is valid only under a database section in the IBM data server driver configuration file (db2dsdriver.cfg) .

<configuration>
  <databases>
      <database name="mydb" host="myhost.ibm.com" port="50000">
                <parameter name="ConnectionTimeout" value="10"/>
                <parameter name="MemberConnectTimeout" value="1"/>
        <wlb>
            <parameter name="enableWLB" value="true"/>
        </wlb>
        <acr>
            <parameter name="enableACR" value="true"/>
            <parameter name="enableSeamlessACR" value="true"/>
        </acr>
      </database>
  </databases>
</configuration>