External Email
Anyone have a utility that checks database locks?

Looking to have a program used to monitor or check for Waiting for locks when or having to start more WEBLISTNR processes.

Currently DBUTIL displays the locks. I’m wanting to possibly put if’s and notification around it.

Helpdesk uses a command to check but occurs in off times and causing a ripple affect in our WEB Service listener. It’s not recovering smoothly if locked for long period of time.

Would be nice to tell the differences between a LOCK or WAITing for a LOCK and number of occurances. I’m more concerned about the Waiting.

]help showloc
USER DEFINED COMMAND FILE:  SHOWLOC.CMD.SFDPROD

PARM dbsh=" "
# COMMAND to show Database locks using DBUTIL without being creator
#         or requiring SM.
# stanfr01 4/13/2009 - inc23752
#requires entry in the Streamx.data.vesoft file for withcaps
# STANFR01 INC#193910 - ADD db'S TO LIST
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
reset audit  >$null
reset cnotdb >$null
reset comm   >$null
reset ecgdb  >$null
reset ersdb  >$null
reset hstmpc >$null
reset prod   >$null
reset wmsdb  >$null
reset xata   >$null
echo show SFD  LOCKS >dbin
echo show SFDAUX LOCKS >>dbin
echo show CIFDB LOCKS >>dbin
echo show DMSINT LOCKS >>dbin
echo show AUDIT  LOCKS >>dbin
echo show CNOTDB LOCKS >>dbin
echo show COMM LOCKS >>dbin
echo show ECGDB LOCKS >>dbin
echo show ERSDB LOCKS >>dbin
echo show HSTMPC LOCKS >>dbin
echo show PROD LOCKS >>dbin
echo show WMSDB LOCKS >>dbin
echo show XATA LOCKS >>dbin
echo exit                        >>dbin
ENDIF
  Withcaps 'SM', run dbutil.pub.sys <dbin

This message is not from a UTC.EDU address. Caution should be used in clicking links and downloading attachments from unknown senders or unexpected email.

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