On 5/25/2011 4:47 PM, Simpkins, Terry wrote:
> 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.

I had a contributed utility called SHOWBASE that will do this a database at a time, w/o
all the dbutil nonsense. 

You could script it with the names of your databases (or pipe them in from a file, I
suspect).

Jeff

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