Caché Parameter File Reference
[Back] [Next]
Go to:

(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.