SDE连接的释放

SDE连接的释放

这里有几个方法移除这种孤进程（orphaned processes）:

·        定期的通过batch文件来重启ArcIMS & ArcSDE，请参考下面连接:
HowTo: Restart ArcIMS Windows Services using a batch file

·        增加TCPKEEPALIVE设置成TRUE在ArcSDE里的giomgr.def文件里来清理没有运行的进程，请参考下面连接:
HowTo: How can I change the timeout for ArcSDE services

·        如果设置了TCPKEEPALIVE为true依然没有清除孤进程（orphaned processes）,运用下面的方法来清除没有意义的进程:

a)打开企业管理器（Enterprise Manager）并且运用SDE用户进入.

b)进入SDE数据库,然后选择表.打开表SDE_process_information.

c)通过START_TIME和OWNER字段来确定会（判断那些进程是没有用的）.

d)选择相应的记录并删除.

e)退出企业管理器（Enterprise Manager）.

f)检查一直在连接的SDE用户，可以通过下面的命令来测试:

sdemon -o info -I users

如果运用ArcIMS image services,另外又选择运用直连的方式（direct connections）进行连接.当这个直连在ARCIMS客户端崩溃时并且ArcSDE Application Server没有运行.如果是这种情况,则当ArcIMS Spatial Server崩溃时,它将占用ArcSDE direct connect进程.

HowTo:如何修改ArcSDE services的timeout（超时）时间

How can I change the timeout for ArcSDE services

Summary

我们有一个参数叫TCPKEEPALIVE在giomgr.defs文件中，这里说明了ArcSDE在一个其进程崩溃后的时间为(7200000ms or 2 hours为默认值)时进行测试.如果在那时没有收到客户端的反应,那么客户端进程和与其关联信息将被清除.

我们可以修改间隔时间来配置操作系统配置缩小到2 hours至5 minutes.

WARNING: This article contains instructions to make specific changes to essential parts of your operating system. If these specific changes are not done correctly, it may cause serious problems to your computer operating system and files. First, ESRI recommends that you make a complete backup of your system, including the registry, before implementing any of the specific changes. It is highly recommended that you consult with your IT/MIS department, or other qualified computer systems professional before proceeding. ESRI cannot guarantee that you can solve problems that result from incorrect use of the Registry Editor utility. Use the Registry Editor utility at your own risk. Note: your operating system and any subsequent service packs may effect these instructions. These instructions are subject to change without notice.

Procedure

• 在Microsoft Windows设置KeepAliveTime为300000.

\HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\TCPIP\Parameters\KeepAliveTime

If the如果这个注册表键值不存在，则要自己创建这个值.
同进这个时间指的是毫秒.

其中当线程资料超过corePoolSize的值时，则线程时间超过KeepAliveTime的则自动断开，KeepAliveTime＝300000。

• 在Sun Solaris使用ndd命令-set选项来进行设置tcp_keepalive_interval配置.

# ndd -set /dev/tcp tcp_keepalive_interval 300000

同进这个时间指的是毫秒.

• 在IBM AIX使用no命令来设置通讯参数s.

no -o tcp_keepidle=591

这个时间指的是半秒单位.

• 在HP HP-UX运用

ndd -set /dev/tcp tcp_time_wait_interva.l 300000

同进这个时间指的是毫秒..

• 在RedHat Linux修改下面文件中的几部分/etc/sysctl.conf文件,并且重启网络daemon (/etc/rc.d/init.d/network restart).

·               # Decrease the time default value for tcp_keepalive_time

tcp_keepalive_time = 1800