 |
» |
|
|
|
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-40 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
|
Session identifier. If the same USERID has multiple connections
to the same DBEnvironment from the same application (including
ISQL), all connections have the same SID.
If the user has multiple connections to the same DBEnvironment
from separate applications, each application (or ISQL session)
will have a different SID.
For more information about multiple DBEnvironment connections,
see the section "Using Multiple Connections and Transactions
with Timeouts" in the "Using ALLBASE/SQL" chapter of the ALLBASE/SQL Reference Manual.
| |
XID
|
INTEGER
|
4
|
Unique transaction identifier
| |
PRIORITY
|
INTEGER
|
4
|
Transaction priority:
| | | | | 0 (highest) - 255 (lowest)
| | ISOLATION LEVEL | CHAR | 2 | Transaction isolation level: | | | | | RR (Repeatable Read, Serializable) | | | | | CS (Cursor Stability) | | | | | RU (Read Uncommitted) | | | | | RC (Read Committed)
| | LABEL | CHAR | 8 | Transaction label string
|
Example | |
select * FROM System.Transaction;
--------------------+-----------+-----------+-----------+-----------
USERID |CID |SID |XID |PRIORITY
--------------------+-----------+-----------+-----------+-----------
JOHN@BROCK | 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
|
|
