IBM 000-8697 ユーザーズマニュアル

IBM Informix OnLine Database Server Administrator’s Guide

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 I

nformix

STAR

. Refer to

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

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

).