Configure TCP KeepAlive settings

The failover design of the messaging engine relies upon the database connections that are broken when a messaging engine instance fails. In order for failover to occur in high availability environments, ensure that the system notices the broken connection in a timely manner and releases database locks. This task is done by configuring the TCP KeepAlive settings.

You must have DB2 database installed and configured on the system.

  1. Log in as a system administrator.
  2. Run these commands on the computer where your DB2 Server is.

    • On the Linux operating system, enter these commands:
      echo 30 >  /proc/sys/net/ipv4/tcp_keepalive_intvl
echo 30 > /proc/sys/net/ipv4/tcp_keepalive_time
      These settings are also used by IPv6 implementations.

    • On the Windows operating system, follow this step:

      Run regedit to edit the Windows Registry key in the HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters directory.

  3. Restart your computer for changes to take effect. For the Linux operating system, run this command:
    # /etc/init.d/network restart

Restart the computer for the changes to take effect.

Parent topic: DB2 database performance tuning tasks


Related