Hi,
running Win2k terminal server and PSQL2000i sp4. We've got a problem,
when a user ends his terminal session it remains in PSQL monitor for
indefinite time until it is deleted manually. After a while quite a
number of such hanging users accumulates. PSQL and win2k TS run on the
same machine. I think the problem is with local sessions because I've
tried to terminate an app from task manager and it hangs in psql
monitor. So it seems to narrow down to this: When a remote app crashes
it disappears from the monitor immediately. When a local app crashes its
corresponding PSQL session remains there forever. Is there any way to
get rid of these hanging users? Thanks in advance.

--
Posted via http://dbforums.com

That is actually expected behavior.
Since the application is not closing the database session, it stays
until the OS network layer tells the engine the session is gone (never
happens for local applications).

Pervasive.SQL V8 has a new feature to take care of this issue.
It watchdogs the local processes and when they go away it will close
the session.

Probably best to have everybody exit the application as the
application vendor intended. The application itself may have pending
work to do and killing it may prevent it from finishing.

Leonard

On Thu, 03 Jul 2003 10:37:34 +0000, Ivan L <member32462 (AT) dbforums (DOT) com>
wrote:

Many thanks, Leonard!

--
Posted via http://dbforums.com