E.9. MON$TRANSACTIONS

MON$TRANSACTIONS reports started transactions.

Column NameData TypeDescription

MON$TRANSACTION_ID

INTEGER

Transaction identifier (number)

MON$ATTACHMENT_ID

INTEGER

Connection identifier

MON$STATE

SMALLINT

Transaction state:

0 - idle 1 - active

MON$TIMESTAMP

TIMESTAMP

The date and time when the transaction was started

MON$TOP_TRANSACTION

INTEGER

Top-level transaction identifier (number)

MON$OLDEST_TRANSACTION

INTEGER

Transaction ID of the oldest [interesting] transaction (OIT)

MON$OLDEST_ACTIVE

INTEGER

Transaction ID of the oldest active transaction (OAT)

MON$ISOLATION_MODE

SMALLINT

Isolation mode (level):

0 - consistency (snapshot table stability) 1 - concurrency (snapshot) 2 - read committed record version 3 - read committed no record version

MON$LOCK_TIMEOUT

SMALLINT

Lock timeout:

-1 - wait forever 0 - no waiting 1 or greater - lock timeout in seconds

MON$READ_ONLY

SMALLINT

Flag indicating whether the transaction is read-only (value 1) or read-write (value 0)

MON$AUTO_COMMIT

SMALLINT

Flag indicating whether automatic commit is used for the transaction (value 1) or not (value 0)

MON$AUTO_UNDO

SMALLINT

Flag indicating whether the logging mechanism automatic undo is used for the transaction (value 1) or not (value 0)

MON$STAT_ID

INTEGER

Statistics identifier