Skip to main content


(Windows and Linux) Number of seconds between keep-alive messages.


[SQL]    TCPKeepAlive=n


TCP Keep-Alive Interval; the number of seconds between keep-alive messages. The default is 300 seconds (5 minutes). The setting applies only to Caché running on Windows and Linux.

You can set this system wide setting from the Caché command prompt by calling:

Set statusCode = $SYSTEM.SQL.SetTCPKeepAlive(<seconds>, .oldVal)

For a TCP device, you can also specify this interval with the OPEN or USE commands, as the eighth parameter (for example: O tcp:("SERVER":port:mode:::::keepalive). or the keyword /KEEPALIVE=n. The OPEN command parameters for a TCP device are: hostname{:port{:mode{:terminators{:ibfsz{:obfsz{:queuesize{:keepalivetime}}}}}}}

For details about the OPEN and USE commands and arguments, including examples, see the Caché ObjectScript Reference.



Range of Values

30–432,000 (5 days). The default is 300. If the value is less than 30, the setting uses 30. If the value is 0, the setting treats this as if it were unset and uses the operating system default.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, enter a value for the TCP Keep Alive Interval (in seconds) setting.

FeedbackOpens in a new tab