Killing orphaned user processes
Jerry Siao
I have a problem killing user processes which have been orphaned (i.e. the user
reset their machine)
For some applications which take a while to complete, some impatient users
simply perform a hard reset on their PC when the application did not return
results in a while (< 2 min)
This causes some problem as the previous user process which is running locked
some tables for processing and I think it is unable to release the lock bec
the connection to the user is no longer available
I can kill processes which are recv sleep ... but those orphaned processes that
are either sleeping, running or PLC wait I have no way of killing them ...
Only thing to do ... restart SQL server ...
Is there anything I can do to kill such processes ??
What is PLC wait? ..
Thanks
Gary Estridge
apparently "hung process". But that doesn't always work...grin. Secondly
you didn't mention what your operating system is or your version of ASE,
make sure that you have the latest EBF's applied for your database(some
EBF's made changes to help decrease the occurrences of orphan processes for
certain OS's and versions). Thirdly check what your TCP/IP keepalive
interval is set at. Most default to 2 hours. This is the setting that lets
the database server know the user is no longer connected. try setting it to
5 min or so. And if that all fails, then you do have to cycle the server to
kill them off, especially the orphan processes that no longer have a spid.
Gary Estridge
Sr. Consultant
Sybase Professional Services
"Jerry Siao" <jer...@mpa.gov.sg> wrote in message
news:tvb40kOf$GA...@forums.sybase.com...
Jerry Siao
Well .. for the records, I am using Sun Solaris 2.6 and running 11.9.2..
as for EBF ... gee thats kinda hard ... but, we've never installed
any patches after installing the ASE 11.9.2 ... (by the way, how do u
check EBF and how to apply them ?)...
One last question ... I noticed on a few occasion, there were PLC sleep
(or is it PLC wait)
in the status column, anybody know what r those? I checked with sybase support
and the engineer that was attending to my case said she never heard of this
term before period. The PLC processes cannot be killed and I have to
restart my dataserver.
On Tue, 22 Feb 2000 00:21:02 -0500,
in sybase.public.sqlserver.general
ibrahim DOGAN
Gary Estridge
SUPPORT and create an account under MySupport. The file containing the
instructions to apply each patch will be listed next to the name of the
download. You check your current version by doing an @@version
Gary Estridge
Sr. Consultant
Sybase Professional Services
"Jerry Siao" <jer...@mpa.gov.sg> wrote in message
news:$8s3kmQf$GA....@forums.sybase.com...