Configuring TCP Keepalives

By default, the Simba Amazon Redshift ODBC Connector is configured to use TCP keepalives to prevent connections from timing out. Settings such as how frequently the connector sends TCP keepalive packets are based on the operating system defaults.

You can set the connection properties described below in a connection string or in a DSN (in the odbc.ini file). Settings in the connection string take precedence over settings in the DSN.

To configure TCP keepalives:

  1. Set the KeepAliveIdle property to the number of seconds of inactivity before the connector sends a TCP keepalive packet.
  2. Set the KeepAliveCount property to the number of keepalive packets that can be lost before the connection is considered broken.
  3. Set the KeepAliveInterval property to the number of seconds to wait before each retransmission of a keepalive packet.

Note:

To use the system default for KeepAliveIdle, KeepAliveCount, or KeepAliveInterval, set the property to 0.

To disable TCP keepalives:

  • Set the KeepAlive property to 0.

Note:

To enable TCP keepalives after disabling them, remove the KeepAlive property or set it to 1.

Related links: