onstat -x的flag

antyison

onstat -x 里flag 是-LX-G

第个L代表什么啊。。。。reference只能查到1、3、5列的含义，第二列的查不到，郁闷。。。。

antyison

嘿嘿，在IBM网站上搜到了

Problem
This document describes the flag values of an onstat -G output for IBM® Informix® Dynamic Server (IDS) versions 9.4x and 10x.  
  
Solution

Q. What are the character flag values of an onstat -G output for IDS versions 9.4x and 10.x?


A. The total width of the flag is five characters long. The table below lists the different character values for each position of the flag.

FLAG VALUES



Position

Value

Description


1

A
C
P
S
User attached to transaction
Cleanup dead transaction
Transaction branch has been prepared (MTS/DTC Only)
Suspended for transaction


2

L
T
Y
MTS/DTC Loose thread
MTS/DTC Tight thread
Transaction branch that yielded the transaction (MTS/DTC Only)


3

B
C
H
P
R
X
Begin work has been logged
Committing or committed
Heuristically aborting or aborted
I-STAR coordinator/subordinate prepared
Aborting or aborted
XA Prepared


4

-
Reserved


5

B
C
G
S
Transaction is either I-STAR coordinator or I-STAR subordinate
Transaction is I-STAR coordinator
Global transaction
Transaction is I-STAR subordinate


EXAMPLE

$ onstat -G

root@scratchy>  onstat -G

IBM Informix Dynamic Server Version 9.40.UC6 -- On-Line -- Up 15:43:25 -- 37476 Kbytes

Global Transaction Identifiers
address  flags  isol    timeout fID     gtl  bql  data
ab8f3a8  ----G  COMMIT  30      0       2    1    48656C
1 active, 128 total


From the above reference, the flag values '----G' signifies that it is a global transaction.