Displays information for each database process.

Sample output for PROMON User Control option

The following shows an example of this option's output. Not all fields in the User Control display fit in a standard window width, but all are described below.

User Control: by user number

  Usr:Ten  Name      Domain     Type     Wait  Table:Part  Dbkey  Trans    PID  Sem Srv   SrvUSr Login  Time IVP#  Remote Address   
    0:0    dba                  BROK     --       0:0          0      0   6492   0    0   0 06/24/14 
    5:3    lobtenant lobtenant  SELF/ABL --       0:0          0      0   7364   0    0   0 06/24/14 
    6:4    lobtenant lobtenant  SELF/ABL --       0:0          0      0   4780   0    0   0 06/24/14 
    7:2    tenant2   tenant2    SELF/ABL --       0:0          0      0   6932   0    0   0 06/24/14 
    8:1    tenant1   tenant1    SELF/ABL --       0:0          0      0   3616   0    0   0 06/24/14 
    9:0    dba                  MON      --       0:0          0      0   7892   0    0   0 06/24/14
   23:0                   0     REMC/ABL --      31:47         0  98676      0  11   2    0 06/24/14 01:05 IPV4 172.16.18.92 

RETURN - repeat, U - continue uninterrupted, Q - quit

Usr:Ten

Displays the user number and tenant ID.

User numbers are assigned sequentially to database processes as they are started. The broker process is always user (0).

Name

The user name for end-user (client) processes.

Domain

The user's domain name.

Type

The table below lists the distinct types of database processes that can appear in the Type field.

Table 1. Process type values

Value	Process type
AIMD	After-image file management utility daemon
AIW	After-image writer (AIW) process
APW	Asynchronous page writer
AUDA	Audit archive utility
AUDL	Audit load utility
BAT	Batch user
BIND	Binary dump utility
BINL	Binary load utility
BIW	Before-image writer
BKUP	Online backup
BROK	Broker process
FMA	OpenEdge Management (formerly Fathom™ Management) Monitor
IACT	Index activate utility
IDXC	Index compact utility
IDXF	Index fix utility
IDXM	Index move utility
MON	Monitor process
PASA	Progress Application Server for OpenEdge Session Manager
PASN	Progress Application Server for OpenEdge Session
PSA	PROSTRCT ADD utility
QUIE	PROQUIET utility
REMC	Remote client
RFUT	RFUTIL utility
RPLA	OpenEdge Replication Site Replication Agent
RPLE	OpenEdge Replication Site Replication online enable
RPLS	OpenEdge Replication Site Replication Server
RPLT	OpenEdge Replication Site Replication Transition
RPLU	OpenEdge Replication Site Replication Utilities
SELF	Self-service client
SERV	Remote-user server
SHUT	Database shutdown process
SQSC	SQLSCHEMA utility
SQDP	SQLDUMP utility
SQLD	SQLLOAD utility
SQSV	SQL server
TBLM	Table move utility
WDOG	Watchdog

Wait

Indicates that a process is waiting for a lock or latch. The table below lists common values and describes the resource or event associated with each value.

Table 2. Possible wait column values

Value	Description
Lock waits
REC	Row (record) lock
IX	Index lock
SCHE	Schema lock
TRAN	Transaction commit
TXB	Transaction end update mode lock
TXE	Transaction end commit mode lock
TXS	Transaction end share lock
TXX	Transaction end exclusive lock
Resource waits
AIRD	After-image buffer read from disk
AIWR	After-image buffer write to disk
BIRD	Before-image buffer read from disk
BIWR	Before-image buffer write to disk
BKEX	Exclusive lock on database buffer
BKSH	Share lock on database buffer
BKSI	Share lock with intent to update on database buffer
BUFF	Shared buffer
DB	Database server
DBBK	Database buffer being backed up
DBRD	Database buffer read from disk
DBWR	Database buffer write to disk
DEAD	Process is waiting to be removed from the process list1
RGET	Row get lock
SRPL	Replication agent acknowledgment
Latch waits
AIB	After-image buffer latch
BFP	Buffer pool latch
BHT	Buffer pool hash table latch
BUF	Buffer pool buffer latch
CPQ	Checkpoint queue latch
DLC	Index delete chain
GST	Global storage pool latch
IXD	Index delete chain latch
LKF	Lock table free chain latch
LKP	Lock table purge chain latch
LKT	Lock table latch
LRS	Secondary LRU chain (not currently implemented)
LRU	Buffer pool LRU chain latch
MTL_RPL	Replication latch
MTX	Log space allocation latch
PWQ	Page writer queue latch
SCH	Shared schema cache latch
SEQ	Sequence cache latch
TXQ	Transaction queue latch
TXT	Transaction table latch
USR	User table latch

You may also see the following values listed in the Wait column:

• BF2
• BF3
• BF4
• BIB
• LRI
• LRX
• OM

The previous values are for short-duration (micro- to milliseconds) latches used internally by the OpenEdge RDBMS.

Table:Part Dbkey

If the user has a REC wait, the combination of the table number, partition number, and the db key, identifies the record. If the table is not table partitioned, the partition number is 0.

Trans

Transaction (task) number, if one is active. After the broker starts, numbers are assigned sequentially to each transaction that accesses the database.

PID

The process ID as assigned by the operating system. The PID column typically displays (0) for remote clients.

Sem

The number of the semaphore the process is using. Each process uses exactly one semaphore. The database engine uses two semaphores (numbers 1 and 2) internally and assigns the remaining semaphores one at a time (starting with the broker) as database processes log in.

Srv

For remote clients (REMC), the server number of the server the client runs against.

SrvUsr

For remote clients (REMC), the user number of the server the client runs against.

Login

The date the process started.

Time

The time the process started.

IPV#

The IP version.

Remote Address