Re: Oracle on MVS

From: <Lawrence>
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

Original text of this message