TCP KeepAlive support

The Db2 driver supports the KeepAlive connection setting, which allows the TCP socket to keep an idle connection active by transmitting packets between the client and server. See "KeepAlive" for more details.

The following steps describe how you can enable this feature for the following operating systems.

Windows:

1. Launch the registry and navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters.
2. Create a KeepAliveInterval parameter of the REG_DWORD type with an interval value in milliseconds. For example, 10000 for 10 seconds.
3. Create a KeepAliveTime parameter of the REG_DWORD type with the number of milliseconds to wait before resending a KeepAlive packet. For example, 3600000 for 1 hour.
4. Restart the operating system.

Linux:

1. Set the time interval between the probes using the following command from the root account:

   echo interval_value > /proc/sys/net/ipv4/tcp_keepalive_intvl

2. Set the maximum number of probes using the following command:

   echo probe_value > /proc/sys/net/ipv4/tcp_keepalive_probes

3. Restart the operating system.

Solaris:

1. Set the KeepAlive interval value using the following command from the root account:

   ndd -set /dev/tcp tcp_keepalive_interval interval_value

2. Restart the operating system.

HP-UX:

1. Set the KeepAlive interval value using the following command from the root account:

   ndd -set /dev/tcp tcp_keepalive_interval interval_value

2. Set the maximum number of probes using the following command:

   ndd -set /dev/tcp tcp_keepalive_kill probe_value

3. Restart the operating system.

AIX:

1. Set the KeepAlive interval value using the following command from the root account:

   no -o tcp_keepidle=interval_value

2. Set the interval between KeepAlive packets to maintain a connection using the following command:

   no -o tcp_keepintvl=interval_value

3. Restart the operating system.