do a
show deadlock
just to see if one exists...
may also do a
show locks
just to see the volume of locks that exist... multiple "show locks" can
indicate if things are getting better or worse and how fast things are
changing...
some processes that are waiting on resources won't cancel out until they can
get that resource... (then drop it and go away)
when a process is canceled out, it often has to wait for lock requests to
clear prior to going away
long wait but something can be helped along if all processes are
canceled
not much help, sorry.
Dwight
> ----------
> From: George Yang[SMTP:[EMAIL PROTECTED]]
> Reply To: ADSM: Dist Stor Manager
> Sent: Friday, August 25, 2000 7:58 AM
> To: [EMAIL PROTECTED]
> Subject: cancel a process taking too long
>
> Hi all,
>
> I am trying to cancel a process, it has been 15 hours, still pending. Is
> some body know how to cancel it fast without halt the server. (I got 40
> sessions waiting).
>
> Thanks
>
> George
>
