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