Terry, I built a quick script to do the same thing on my primary DB's. It uses MPEX and STREAMX to get by some of the SECURITY of having to be creator and changing groups. Allows Helpdesk to check very quickly..





showloc



THU, MAY 26, 2011,  9:41 AM

HP30391C.10.01 TurboIMAGE/XL:  DBUTIL (C) COPYRIGHT HEWLETT-PACKARD COMPANY 1987

>>  For database SFD



  No locks are held.

>>  For database SFDAUX



  No locks are held.

>>  For database CIFDB



  No locks are held.

>>  For database DMSINT



  No locks are held.

>>





USER DEFINED COMMAND FILE:  SHOWLOC.CMD.SFDPROD



PARM dbsh=" "

# COMMAND to show Database locks using DBUTIL without being creator

#         or requiring GOD.

# stanfr01 4/13/2009 - inc23752

#requires entry in the Streamx.data.vesoft file for withcaps

setjcw insidempex = 0

if insidempex <> 1 then

   run main.pub.vesoft;parm=1;info="!hpfile !DBSH"

   return

endif

SETVAR DBSHP "!DBSH"

showtime

IF DBSHP > " "

reset !dbshP  > $null

echo show !dbshP  LOCKS >dbin

echo exit                        >>dbin

ELSE

reset sfd  > $null

reset sfdaux  > $null

reset cifdb   > $null

reset dmsint   > $null

echo show SFD  LOCKS >dbin

echo show SFDAUX LOCKS >>dbin

echo show CIFDB LOCKS >>dbin

echo show DMSINT LOCKS >>dbin

echo exit                        >>dbin

ENDIF

  Withcaps 'SM', run dbutil.pub.sys <dbin



Randy Stanfield

Unisource- Dallas

972-982-3621





Date:    Wed, 25 May 2011 20:47:48 +0000

From:    "Simpkins, Terry" <[log in to unmask]>

Subject: how to see all image locks held



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 *