Script to check Lock Table size
The following unix script should be set in cron. I run it every 5 min.
It will email everyone on EMAILLIST when Lock Table will be over 30000.
The value is set in progress program LockTableWatch.p. It will also report the users that have more than 500 locks.
$DLC/bin/_progres -b -db db-name -p LockTableWatch.p
if [ -f /tmp/LockTableWatch.out ]
cat /tmp/LockTableWatch.out | mail -s "Check Lock Table" -e "$EMAILLIST"