Kbase P17090: How to obtain information about the currently connected users of a database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/10/2007 |
|
Status: Verified
GOAL:
How to obtain information about the currently connected users of a database
GOAL:
What information can be obtained from the _Connect VST?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
Information about the users that are connected to the database can be obtained from the _Connect virtual system table:
Some fields in this virtual system table are:
_connect-type: gives if the connection is SELF (shared memory) or REMC
(remote), APW, FMA (is the Fathom agent that is monitoring
this DB), ...
_connect-name: gives the userid connected (problem there can be several
sessions with same userid)
_connect-device: gives the device, i.e. /dev/pts/1 in UNIX self service, for
remote connections it gives the remote machine name
_connect-pid: gives the pid that can be used to kill or disconnect the user
_connect-batch: gives if the connected process is running in batch or not