Kbase P103179: How to determine semaphore ID used by Progress database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/14/2005 |
|
Status: Unverified
GOAL:
How to determine semaphore ID used by Progress database
FACT(s) (Environment):
UNIX
FIX:
One way to retrieve such an information is to query _Connect VST table and display _Connect_SemID field.
Another way will be to run a script similar to the one below:
*********************************
#!/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
************************
The 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.