Kbase P11086: How to gather information on user connections?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
How to gather information on user connections?
FIX:
The Virtual System Table _Connect stores information on the current user connections.
For gathering information on all the connections made to the database server, you can also parse the database log file showing
. the following messages for connection and disconnection of a self service user
<TIME> Usr <num>:Login by <user> on <ttyxxx>. (452)
<TIME> Usr <num>:Logout by <user> on <ttyxxx>. (453)
. the following messages for connection and disconnection of a remote user
<TIME> SRV <num>:Login usernum <num>, userid <name>, on <tty
ode>. (742)
<TIME> SRV <num>:Logout usernum <num>, userid <name>, on <tty
ode>. (739)