Kbase 17484: Using proutil -C dbipcs to gather semaphore information
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Using proutil -C dbipcs to gather semaphore information
The proutil -C dbipcs command only returns shared memory information
relative to Progress databases. Sometimes it is more, or equally
important to know semaphore information. This is not currently
available from proutil. The following script will return the SEMID
and the name of the Progress databases that are "InUse."
This script should be used in conjunction with Progress error (1075)
in the dbname.lg.
======================== Start of script dbipcs-s ================
#!/bin/sh
dbipcs_s=${dbipcs_s-./dbipcs-s.log};export dbipcs_s
date >>$dbipcs_s
InUse=`proutil -C dbipcs |awk '$4 == "Yes" {print $1}'`
Database=`proutil -C dbipcs |awk '$4 == "Yes" {print $5}'`
for Id in $InUse
do
Owner=`ipcs -m |grep '^m'|grep $Id |awk '{print $5}'`
ipcs -s |grep $Owner | awk '{printf ("Semid %d in use by "), $2}'
>>$dbipcs_s
echo $Database >>$dbipcs_s
done
======================== End of script dbipcs-s ================
This script will save its output in the current working directory in
a file called dbipcs-s.log. If you wish to save it elsewhere, or by
a different name, simple define the variable dbipcs_s before calling
the script.
This script should be called prior to starting the database, and
periodically while the database is running.
NOTE: The line containing >>$dbipcs_s is folded from the line above it
and actually belongs on the end of that line.
12/16/97 JGH
Progress Software Technical Support Note # 17484