Output Description

address

Is the in-memory address of the transaction control block

XTM-Id

Is the global transaction ID

flags

Is the current status of the global transaction using a combination of the following hexadecimal values:

x00000001

Open transaction

x00000002

TP/XA global transaction

x00000004

Transaction marked as abort only

x00000008

Prepared TP/XA transaction

x00000010

Prepared distributed transaction

x00000020

Aborted transaction

x00000040

Committed transaction

x00000080

Heuristically completed transaction

x00000100

BEGIN WORK log record written

x00000200

Started committing dropped tables and indexes

x00000400

Started aborting the transaction

x00000800

Save point log delay

x00001000

Save point rollback

x00008000

Save point has begun

x00010000

Coordinator in a distributed query

x00020000

Subordinate/participant in a distributed query

x00040000

Global save point is active

fID

Is the format ID for transaction data

gtl

Is the length of the global transaction

bql

Is the length of the byte stream for the transaction

data

Is the hexadecimal dump of the transaction ID and data

Summary Definitions

active

Is the number of active global transactions

total

Is the current number of transactions dynamically allocated to the database server