| Rob Verschoor 2005-04-03, 8:02 pm |
| Are you sure it's really a 'zombie'? hav eyou verified the spid isn't
rolling back a long transaction (if so, sysprocesses.physical_io is
increasing for the spid).
If it's really not doing anything than your only option is to reboot ASE.
HTH,
Rob
-------------------------------------------------------------
Rob Verschoor
Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase
Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------
<Sudarshan> wrote in message news:424da0ec$1@foru
ms-2-dub...
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp
|