How does one automatically disable idle SDE connections? [Reprinted]

How does one automatically disable idle SDE connections? [Reprinted]

Http://www.ggiiss.com/gis/d4/472.html

In Sde-connected applications, if there are many connected customers, the SDE connection may occupy a lot of CPU resources, so that the system crashes.

SDE provides the tcpkeepalive parameter to detect client connections. When tcpkeepalive is set to true, it is set to 2 hours (timeout is set by default ).
Within 7200000 ms (2 hours), if the client does not send a request to SDE, the SDE connection will be closed automatically. If the value of tcpkeepalive is false, when the client does not
If a request sent to SDE exceeds the time specified by timeout, the SDE connection is still in use. Therefore, if we want the system to automatically disable idle SDE connections
Set tcpkeepalive to true. The default value of tcpkeepalive during installation is false.

The tcpkeepalive parameter can be changed using the SDE command, for example:
Sdeconfig-O alter-V tcpkeepalive = true-u Sde-P SDE
Restart the SDE service.

Note: The tcpkeepalive parameter does not work when SDE is directly connected to the application.

The timeout time of tcpkeepalive can be changed. We can change the operating system to set the timeout interval (5 minutes-2 hours ). For example:
On Microsoft Windows Set KeepAliveTime to 300000.
\ HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ Tcpip \ Parameters \ KeepAliveTime
If the key does not already exist you will need to create it.
The time specified is in milliseconds.
On Sun Solaris use the NDD command with the-set Option to configure the tcp_keepalive_interval.

# NDD-set/dev/tcp tcp_keepalive_interval 300000

The time specified is in milliseconds.

On ibm aix use the no command to set communication parameters.
No-o tcp_keepidle = 591

The time specified is in halfseconds.

On HP HP-UX use

NDD-set/dev/tcp tcp_time_wait_interval 300000

The time specified is in milliseconds.

On Redhat Linux modify the following Kernel Parameter by editing
The/etc/sysctl. conf file, and restart the network daemon
(/Etc/rc. d/init. d/network restart ).

# Decrease the time default value for tcp_keepalive_time

Tcp_keepalive_time = 1800