HP3000-L Archives

May 2002, Week 3

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Impeded Processes
From:
Tom of Bunyon <[log in to unmask]>
Reply To:
Tom of Bunyon <[log in to unmask]>
Date:
Thu, 16 May 2002 19:02:19 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (65 lines) 
It might be in a Socket-wait for a process elsewhere.


"Knight, Sam" <[log in to unmask]> wrote in message
news:ac0l4o020oh@enews4.newsguy.com...
> No locks are showing for any databases, according to DBUTIL.
>
> Glance is what is showing the job has impeded processes.  Are
> there other utilities that might give more info as to what is
> going on?
>
> ****************************************************************
>
> Sam Knight                      Phone   (904)745-7509
> Sr. Programmer/Analyst  Fax     (904)745-7238
> Jacksonville University
> Jacksonville, FL 32211
>
>
>
>
> -----Original Message-----
> From: Michael Berkowitz [mailto:[log in to unmask]]
> Sent: Thursday, May 16, 2002 11:28 AM
> To: 'Knight, Sam'; [log in to unmask]
> Subject: RE: Impeded Processes
>
>
> Sam Knight writes
>
> Anyone have any suggestions as to how to abort a job that
> has several impeded processes.  Abortjob does nothing.
> -------------------------------------------------------------------
> Most likely, your jobs are sitting on an unconditional DBLOCK waiting for
> another process to release their lock.  At this point you are setcritical
> and are unabortable.  To determine what's holding the lock,
>
> :RUN DBUTIL.PUB.SYS
> >SHOW yourdatabase LOCKS
>
> After you are shown the offender holding the lock, you have several
options.
> 1.  Abort the lock holder
> 2.  Abort the lock holder and slash their car's tires
> 3.  Abort the lock holder and pummel the programmer that wrote a program
> that holds a lock for a
>     long time.
>
> If the person holding the lock is also waiting for another lock (a deadly
> embrace) you must use program UNDEDLOK.PRVXL.TELESUP to remove the
offender
> and free up everone else.  After this is done, you may do part B of choice
3
> above for their outstanding programming job.
>
> Mike Berkowitz
> Guess? Inc.
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2