User Information Viewer

img00100 The User Information Viewer allows the user to drill down and focus on one particular database connection. Select the user by user number (press the '#' key) or PID (press the 'P' key) (see the help screen).


img00200
Click here for more information on the "Set DB Connection Number" screen.


img00300
Click here for more information on the "Set DB Connection Process ID" screen.


img00400

User Information Dashboard

First column

ProTop RT Label Alertable Metric* Description
Login Name N/A Login Name of the User being viewed
Usr # usrNum User Number of the User being viewed
Connection Id N/A Connection Id of the User being viewed
PID usrPID OS process ID
TID N/A Process thread ID. In OpenEdge v11 and v12, the only client processes that are multi-threaded are PASOE agents.
Session Info N/A See below
TRX Info N/A Transaction information

Session Info values

Flag Description
Type ABL or SQL
Cnx Self service or remote client server
S Shared memory client
R Remote client
L Login broker
@ Server
H helper
O Other
4 4GL Client
W Webspeed client
B Batch client
A Application server
P PASOE
Q SQL
X Unknown
* Transaction active
d Disconnecting
r Undo or error
I STOP or Ctrl-c
N- Notification pending
-N Notification in process
NN Notification pending and in process


Second Column

ProTop RT Label Alertable Metric* Description
Login Time usrLoginTm Date and time the User connected to the database server
Device/IP usrIPAddr If connected via shared memory, the device (tty) associated with the process. If connected via Remote Client, the IP address.
Full Name N/A Full name of the user, if available
Phone N/A Phone number of the user, if available
E-Mail N/A E-Mail address of the user, if available


Third Column

ProTop RT Label Alertable Metric* Description
-Bp Bufs N/A The maximum number of private read-only buffers set at client startup
-Bp Used N/A The current number of private read-only buffers
Server usrSrv For client/server connections, the user's server connection ID
Serv PID N/A Server OS process ID
Serv TID N/A Server Thread ID. As of OpenEdge 12, server processes are multi-threaded


Fourth Column

ProTop RT Label Alertable Metric* Description
BI Reads N/A Number of BI Reads by the usercmd
BI Writes N/A Number of BI Writes by the user
AI Reads N/A Number of AI Reads by the user
AI Writes N/A Number of AI Writes by the user


Fifth Column

ProTop RT Label Alertable Metric* Description
Logical Rd N/A Number of logical read by the user
Logical Wr N/A Number of logical written by the user
Disk Reads tblOSRd Number of operating system reads by the user
Hit % N/A Percentage of logical reads from the database buffer cache
Num Trx N/A Number of committed transactions by the user
Curr Locks N/A Number of records currently locked by the user
Lock HWM N/A High water mark of concurrent locks

User Information Session Table Activity

User Information Session Index Activity

User Information Session 4GL Call Stack

User Information User's Other Sessions