Re: Oracle on MVS
Date: 1996/08/30
Message-ID: <506rn3$17r_at_lex.zippo.com>#1/1
In article <5052cb$e2r_at_lal.interserv.com>, sali_at_ci.chi.il.us says...
>
>We have Oracle 7.2.3 running on MVS system under a subsystem. The clients login
>using Windows 3.1 and SQL*Net 2.1.
>
>Our problem is whenever a user shutdown his/her pc without exiting properly from
>from Windows or he/she gets a gpf on windows, there is a hanging thread on the
>Oracle on MVS. This type of threads are cleaned by Oracle on other platforms if
>the connection is dead. However, on MVS this is not happening. We tried to change
>the dead connection related parameters. None helped.
>
You don't say what protocol you are using. And you are not alone. This is a
problem on other platforms. You may be able to set a time out at the protocol
level. Basically the problem is that all conversations are intiated by the
client. The server waits patiently for requests. If a request doesn't come
for 20 minutes is that ok, maybe, 2hrs, maybe, etc.
Some people write 'cleanup' jobs that run nightly and kill service processes. SQLNet 2 may be a new problem. Good luck!!!
Lawrence..... Received on Fri Aug 30 1996 - 00:00:00 CEST