A. Command Reference : iimonitor Command--Administer DBMS, Recovery, and GCF Servers : Show Sessions Command : Transaction Mode and Information in Command Output
 
Share this page                  
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.