Common IBM Data Server Driver for JDBC and SQLJ properties for IBM Informix and Db2 on Linux, UNIX, and Windows systems

Properties that apply to IBM Informix and Db2 on Linux, UNIX, and Windows systems are:

memberConnectTimeout

Specifies the amount of time in seconds before an attempt to open a socket to a member of a Db2 for z/OS® data sharing group, Db2 pureScale® instance, or IBM Informix high availability cluster fails. The data type of this property is int.

memberConnectTimeout applies only to socket connection attempts to different members during automatic client reroute processing. The memberConnectTimeout property takes precedence over the loginTimeout property.

The default is 0.

If the memberConnectTimeout value is less than or equal to 0, the driver uses the loginTimeout value to determine how long to wait before it fails a connection request.

The memberConnectTimeout value is used for every socket open operation to each member in a member list.

For a connection to a Db2 for z/OS data sharing group, after all attempts to open a socket to all members fail, the driver retries the socket open by using a group IP address. For that retry, the driver uses the loginTimeout value to determine how long to wait before it fails the connection request.