Greetings,

Thanks to all who gave suggestions.  The approach that will work best
for me is to use the %WITHCAPS command of MPEX.  

I am grateful to Randy Stanfield for an elegant sample command file.

Walter  

-----Original Message-----
From: Walter J. Murray [mailto:[log in to unmask]] 
Sent: Sunday, April 12, 2009 12:26 PM
To: [log in to unmask]
Subject: How to see what's locked in a TurboIMAGE database

Greetings,

I am looking for a way to permit ordinary users (programmers and support
staff) to see who is using a TurboIMAGE database, and what locks are in
effect and are pending--the information you would see with DBUTIL using
SHOW ... USERS and SHOW ... LOCKS or SHOW ... ALL.

I have to work within these constraints:  (1) Can't let them log on with
SM capability.  (2) Can't let them log on as the database creator.  (3)
Can't reveal the password on the MPEX GOD program.  (4) Can't reveal the
password on DBUTIL.

Any suggestions?  Any utility to do this?

My best idea so far is to set up a command file that would use the MPEX
%WITHCAPS command to grant SM capability temporarily, then run DBUTIL.

Walter  

Walter J. Murray

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