 |
» |
|
|
|
SYSTEM.TRANSACTION is a pseudotable that records the transactions
of users currently accessing the DBEnvironment. SYSTEM.TRANSACTION supports an unlimited number of users,
transactions, and sessions. Table 8-38 System.Transaction | Column Name | Type | Length | Description |
|---|
| USERID | CHAR | 20 | DBEUserID of the user who started the transaction | | CID | INTEGER | 4 | Unique connection identifier | | SID | INTEGER | 4 | Unique session identifier | | XID | INTEGER | 4 | Unique transaction identifier
| | PRIORITY | INTEGER | 4 | 0 (highest) - 255 (lowest)
| | ISOLATION LEVEL | CHAR | 2 | Transaction isolation level: RR (Repeatable Read, Serializable)
| | LABEL | CHAR | 8 | Transaction label string |
EXAMPLE | |
SELECT * FROM System.Transaction;
--------------------+-----------+-----------+-----------+-----------
USERID |CID |SID |XID |PRIORITY
--------------------+-----------+-----------+-----------+-----------
JOHN | 108| 108| 11320| 127
---------------------------------------------------------------------------
Number of rows selected is 1
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> r
--------------------+---------
ISOLATION LEVEL |LABEL
--------------------+---------
RC +Xact2
------------------------------
Number of rows selected is 1
|
|
