http://www.allegro.com/software/hp3000/stuff/TBLTEST.txt \SEMAPHORES, CBLOCKS SEMaphore <kind> [options] [dest] kind ::= semaphore_address | PIN <# | ALL> | PORTarea address | SHARED | ANALYZE options ::= <FOLLOW | HEXdump | OWNed | PRIOR | Verbose | WAITing>* dest ::= TO filename | APPENDTO filename | > filename | >> filename The SEMAPHORE ANALYZE command searches for deadlocks involving semaphores (control blocks). The SEMAPHORE PIN ALL command lists processes holding semaphores. default: SEM PINS ALL WAITING (just to clarify craig's somewhat terse shorthand ;-) - d --- Donna Hofmeister Allegro Consultants, Inc. 408-252-2330 > -----Original Message----- > From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of Craig Lalley > Sent: Wednesday, May 25, 2011 2:02 PM > To: [log in to unmask] > Subject: Re: [HP3000-L] how to see all image locks held > > Terry, > > TBLTEST.PUB.ALLEGRO > > SEM ANAL > > > > Tbltest is free from Allegro's web site.... one of the most awesome tools ever created for the HP3000. > > Since the tool is free, it is not a plug. :-) > > -Craig > > > --- On Wed, 5/25/11, Simpkins, Terry <[log in to unmask]> wrote: > > From: Simpkins, Terry <[log in to unmask]> > Subject: how to see all image locks held > To: [log in to unmask] > Date: Wednesday, May 25, 2011, 1:47 PM > > Is there any way to quickly see all IMAGE locks held on all IMAGE DBs across multiple groups & > accounts? > Of course I can logon as the DB creator in each group in each account, use DBUTIL to SHOW LOCKS for > each database. > > In my environment, with 100+ IMAGE databases spread across 25+ groups in 5 accounts, this is not a > practical solution. The problem will be 'gone' before I get to the offending DB. > I suppose I can create a script file that will do this, but I thought someone may have already solved > this problem/requirement. > > Any ideas? > > Terry W. Simpkins > Director Business Systems > Measurement Specialties, Inc. > office: +1 757-766-4278 > mobile: +1 757 532-5685 > [log in to unmask]<mailto:[log in to unmask]> > www.meas-spec.com<http://www.meas-spec.com> > > > * 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 * * To join/leave the list, search archives, change list settings, * * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *