TCPKeepAlive
Synopsis
[SQL] TCPKeepAlive=n
n is an integer in the range 30—432,000. The default value is 300.
Description
TCPKeepAlive is the number of seconds between keep-alive messages. The setting applies only to InterSystems IRIS® data platform running on Windows and Linux. The default is 300 seconds (5 minutes), and the maximum value is 432,000 (5 days). If the value is 0, the instance uses the operating system default.
For further details, see TCP Client/Server Communication.
Changing This Parameter
On the SQL page of the Management Portal (System Administration > Configuration > SQL and Object Settings > SQL), enter a value for the TCP keepalive for client connections (seconds) setting.
To set the desired value for TCPKeepAlive from the InterSystems Terminal, use the SetOption(“TCPKeepAlive”)Opens in a new tab method of the %SYSTEM.SQL.UtilOpens in a new tab class. See the class reference for details.
You can also change TCPKeepAlive with the Config.SQLOpens in a new tab class (as described in the class reference) or by editing the CPF in a text editor (as described in Editing the Active CPF).
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 ObjectScript Reference.