Subject: | |
From: | |
Reply To: | Stanfield, Randy (Carrollton, TX) |
Date: | Mon, 13 Apr 2009 12:58:07 -0500 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Use MPEX's WITHCAPS and a command file. Hopefully this helps.
Command file.
print showloc.cmd.sfdsw
PARM dbsh=SFD
setjcw insidempex = 0
if insidempex <> 1 then
run main.pub.vesoft;parm=1;info="!hpfile !DBSH"
return
endif
showtime
echo show !dbsh LOCKS >dbin
echo show DMSINT LOCKS >>dbin
echo show SFDAUX LOCKS >>dbin
echo exit >>dbin
Withcaps 'SM', &
run dbutil.pub.sys <dbin
Entry Added to Streamx.data.vesoft
$WITHCAPS-PERMIT @.@ showloc.cmd.sfdsw "SM"
Date: Sun, 12 Apr 2009 12:26:17 -0700
From: "Walter J. Murray" <[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 *
|
|
|