Try OpenEdge Now
skip to main content
Database Administration
Reference : PROMON Utility : PROMON User Control option
 

PROMON User Control option

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   Login Time IVP# Remote Address   
    0:0    dba                  BROK     --       0:0        0      0   6492   0    0  06/24/14
    5:3    lobtenant lobtenant  SELF/ABL --       0:0        0      0   7364   0    0  06/24/14
    6:4    lobtenant lobtenant  SELF/ABL --       0:0        0      0   4780   0    0  06/24/14
    7:2    tenant2   tenant2    SELF/ABL --       0:0        0      0   6932   0    0  06/24/14
    8:1    tenant1   tenant1    SELF/ABL --       0:0        0      0   3616   0    0  06/24/14
    9:0    dba                  MON      --       0:0        0      0   7892   0    0  06/24/14
23:0 0 REMC/ABL -- 31:47 0 98676 0 11 2 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 76. 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 77. 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
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

1 Seen when a process is terminated with the UNIX kill-9 command

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 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