Transaction Mode and Information in Command Output
The output of the show sessions formatted command or formatted sessionid command shows the following, among other items:
Modes: DB: RW Sess: RW Txn: multi,rw Onerror-rollback: stmt
X100 session ID: 1 X100 txn ID: 1672
Modes
The current state of various transaction modes:
DB: xx
Whether database is read only (RO) or read write (RW).
Sess: xx
Whether a session is read only (RO) (SET SESSION READ ONLY has been issued) or read write (RW).
Txn: tttt,yyy
The current transaction state, where
tttt is:
none - No transaction is active
single - A single statement transaction is active (will be autocommitted)
multi - A multi-statement transaction is active (needs an explicit commit or rollback)
yyy is:
rw - Read write
ro - Read only
vro - The Ingres side is read write but the Vector side is read only. This state can occur for cursors.
Onerror-rollback: zzzz
The current on_error rollback action, where zzzz is:
stmt (Default) - Roll back statement
txn - Roll back transaction
X100 session ID
Vector session ID (shown in the first column of vwinfo -o output)
x100 txn ID
The Vector transaction ID, if known.
Note: A read-only transaction ID is typically 0 (zero), which means that Vector does not need to know the x100 transaction ID. Use the vwinfo dbname -o command to find a Vector session transaction ID. The x100 txn ID is also 0 for a session in a "none" transaction state.