Sam
Do your impeding process have a file open on a printer that should
be spooled? A SHOWOUT job=impeding job number would show if it had
a printer HOT. If so, do an OPENQ on the device and then ABORTIO
on the device. The job should then terminate.
Bob Schlosser - MPE-CSM
Ochsner Health Plan
(504) 219-8134
-----Original Message-----
From: Knight, Sam [mailto:[log in to unmask]]
Sent: Thursday, May 16, 2002 10:48 AM
To: [log in to unmask]
Subject: Re: Impeded Processes
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 *
|
