DB2句柄泄漏？ [英] DB2 Handle Leak?
问题描述
我在Windows 2000 Server上使用DB2 8.5 FP5并注意到出现
是一个句柄泄漏。当我在命令
窗口中执行DB2 connect语句，然后执行DB2 connect reset语句时，在Windows任务管理器中为db2syscs进程显示的句柄数
不返回
到原来的价值，但要高出1个。
虽然这在大多数情况下不是一个严重的问题，但我们有应用程序
每30秒左右连接一次，预计它们的上升时间为b / b $ b个月。我们已经看到把手列在~20,000，当他们开始时
~300。
任何人都可以确认这是一个真正的问题还是这只是在任务管理器中显示
奇怪？
I am using DB2 8.5 FP5 on Windows 2000 Server and have noticed what appears
to be a handle leak. When I execute a DB2 connect statement in a command
window, followed by a DB2 connect reset statement, The number of handles
displayed in Windows Task Manager for the db2syscs process does not return
to its original value, but to 1 handle higher.
While this is not a serious issue most of the time, we have applications
connecting every 30 seconds or so and they are expected to have up-times of
months. We have seen the handles listed at ~20,000, when they start at
~300.
Can anyone confirm whether this is a real issue or is this just a display
oddity in Task Manager?
推荐答案
Ken Brubaker写道：
Ken Brubaker wrote:
我在Windows 2000 Server上使用DB2 8.5 FP5并且已经注意到
出现的句柄泄漏。当我在命令窗口中执行DB2连接语句，然后执行DB2连接重置语句时，Windows任务管理器中显示的db2syscs进程的句柄数量不会返回给它原来的价值，但要高一个。
虽然这在大多数时间都不是一个严重的问题，但我们有应用程序每30秒左右连接一次，他们预计会有 -
几个月。当他们从
~300开始时，我们已经看到了大约20,000的手柄。
任何人都可以确认这是一个真正的问题还是只是一个显示器奇怪的任务管理器？
I am using DB2 8.5 FP5 on Windows 2000 Server and have noticed what
appears
to be a handle leak. When I execute a DB2 connect statement in a command
window, followed by a DB2 connect reset statement, The number of handles
displayed in Windows Task Manager for the db2syscs process does not return
to its original value, but to 1 handle higher.
While this is not a serious issue most of the time, we have applications
connecting every 30 seconds or so and they are expected to have up-times
of
months. We have seen the handles listed at ~20,000, when they start at
~300.
Can anyone confirm whether this is a real issue or is this just a display
oddity in Task Manager?
也许您正在使用代理池？什么是dbm cfg的设置
参数NUM_POOLAGENTS？
-
Knut Stolze
信息集成
IBM德国/耶拿大学
Maybe you are using agent pooling? What''s the setting of the dbm cfg
parameter NUM_POOLAGENTS?
--
Knut Stolze
Information Integration
IBM Germany / University of Jena
NUM_POOLAGENTS的默认值为100.
" Knut Stolze" < ST **** @ de.ibm.com>在消息中写道
news：c5 ********** @ fsuj29.rz.uni-jena.de ...
The NUM_POOLAGENTS has been left at the default value of 100.
"Knut Stolze" <st****@de.ibm.com> wrote in message
news:c5**********@fsuj29.rz.uni-jena.de...
Ken Brubaker写道：
Ken Brubaker wrote:
我在Windows 2000 Server上使用DB2 8.5 FP5，并注意到
出现了句柄泄漏的问题。当我在
命令窗口中执行DB2 connect语句，然后执行DB2 connect reset语句时，在Windows任务管理器中为db2syscs进程显示的句柄数量不会返回到
原来的价值，但要高一个。
虽然这在大多数时间都不是一个严重的问题，但我们有应用程序每30秒左右连接一次，他们预计会有 -
几个月。当他们从
~300开始时，我们已经看到了大约20,000的手柄。
任何人都可以确认这是一个真正的问题，还是这只是
显示奇怪的任务管理器？
I am using DB2 8.5 FP5 on Windows 2000 Server and have noticed what
appears
to be a handle leak. When I execute a DB2 connect statement in a command window, followed by a DB2 connect reset statement, The number of handles
displayed in Windows Task Manager for the db2syscs process does not return to its original value, but to 1 handle higher.
While this is not a serious issue most of the time, we have applications
connecting every 30 seconds or so and they are expected to have up-times
of
months. We have seen the handles listed at ~20,000, when they start at
~300.
Can anyone confirm whether this is a real issue or is this just a display oddity in Task Manager?
也许您正在使用代理池？什么是dbm cfg的设置
参数NUM_POOLAGENTS？
-
Knut Stolze
信息集成
IBM德国/耶拿大学
Maybe you are using agent pooling? What''s the setting of the dbm cfg
parameter NUM_POOLAGENTS?
--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Ken Brubaker写道：
Ken Brubaker wrote:
NUM_POOLAGENTS的默认值为100。
The NUM_POOLAGENTS has been left at the default value of 100.
NUM_INITAGENTS设置为什么？我相信默认值为0.
NUM_POOLAGENTS定义了DB2将保持活动的代理程序数量（在应用程序与数据库断开连接后为
）以避免
启动新代理的开销。
NUM_INITAGENTS指定启动
实例时DB2启动的代理程序数。 />
如果NUM_INITAGENTS< NUM_POOLAGENTS，然后您可以看到您描述的行为
，直到您拥有> NUM_POOLAGENTS
与数据库的活动连接。
祝你好运，
----- =通过Newsfeeds.Com发布，未经审查的Usenet新闻= -----
http://www.newsfeeds.com - 世界排名第一的新闻组服务！
----- ==超过100,000个新闻组 - 19个不同的服务器！ = -----
What is NUM_INITAGENTS set to? I believe the default is 0.
NUM_POOLAGENTS defines how many agents DB2 will keep alive (after
an application disconnects from the database) in order to avoid
the overhead of starting new agents.
NUM_INITAGENTS specifies the number of agents DB2 starts when the
instance is started.
If NUM_INITAGENTS < NUM_POOLAGENTS, then you could see the behavior
that you describe, up to the point where you have > NUM_POOLAGENTS
active connections to the database.
Good luck,
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
这篇关于DB2句柄泄漏？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
