7-100 IBM Informix OnLine Database Server Administrator’s Guide
Option Descriptions
Thesecond section of the -u output describes transactions. This information
is required only for anX/Open environment or in some situations in which
OnLine is participating in queries managed byIBM Informix STAR. Refer to
page 9-58 for a detailed description of the transactions section.
Theflag codes for position 2 refer to the state of the transaction
attached to this user process, or if the process is an archive
process:
A
B
C
H
P
R
T
X
archive process
transaction has been initiated
transaction is committed or is committing
transactionwas heuristically aborted or is in the process
of doing so
prepare state; this transaction has been precommitted
inrollback mode; transaction was aborted or is aborting
ina transaction (work in progress); logging has occurred
transactionis XA-prepared or is in the process of doing
so
Theflag codes for position 3 describe the user process activity
(if it is reading or writing):
R
Xreading
inside a write call, checkpoints prevented from
occurring
The flag codes for position 4 identify the user process type:
M
D
C
F
aDB-Monitor (monitor) process
a daemon process
terminated user process waiting for cleanup
a page-cleaner daemon (tbpgcl)
pid is the process identification number (derived fromUNIX).
user is the user login name (derived fromUNIX).
tty indicates the tty that the user is using (derived fromUNIX).