Filter
Top Products
7-100 IBM Informix OnLine Database Server Administrator’s Guide
Option Descriptions
The second section of the -u output describes transactions. This information
is required only for an X/Open environment or in some situations in which
OnLine is participating in queries managed by IBM Informix STAR. Refer to
page 9-58 for a detailed description of the transactions section.
The flag 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
transaction was heuristically aborted or is in the process
of doing so
prepare state; this transaction has been precommitted
in rollback mode; transaction was aborted or is aborting
in a transaction (work in progress); logging has occurred
transaction is XA-prepared or is in the process of doing
so
The flag codes for position 3 describe the user process activity
(if it is reading or writing):
R
X
reading
inside a write call, checkpoints prevented from
occurring
The flag codes for position 4 identify the user process type:
M
D
C
F
a DB-Monitor (monitor) process
a daemon process
terminated user process waiting for cleanup
a page-cleaner daemon (tbpgcl)
pid is the process identification number (derived from UNIX).
user is the user login name (derived from UNIX).
tty indicates the tty that the user is using (derived from UNIX).