Kbase P117372: 4GL Program to identify users / processes connected to a database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/07/2006 |
|
Status: Unverified
GOAL:
Program to determine processes connected to a database.
GOAL:
Program to determine which users are connected to a database.
GOAL:
Program that can be ran in batch mode to determine which users or processes are connected to a database.
FIX:
The following program can be ran in batch mode to determine which user processes are connected to a database. The program is a 4GL program that makes use of the _Connect VST (Virtual System Table). This program can be ran via a batch Progress client. The command can also be added to a cron job or scheduler program to be executed on a regular basis.
Sample command:
mbpro dbname -p connusers.p
The follow lines of code should be added to a file called connusers.p
Please note, that /tmp/usr.report is the file name where the report will be directed to. This name can be chanced to whatever you like.
output to /tmp/usr.report.
for each _connect no-lock where _connect-usr > 0:
display _connect-usr _connect-type _connect-name _connect-pid _connect-time.
end.
output close.