master database only
systransactions contains information about Adaptive Server transactions, but it is not a normal table. Portions of the table are built dynamically when queried by a user, while other portions are stored in the master database. Updates to the dynamically-built columns of systransactions are not allowed.
The columns for systransactions are:
Name |
Datatype |
Description |
---|---|---|
xactkey |
binary(14) |
Unique Adaptive Server transaction key |
starttime |
datetime |
Date the transaction started |
failover |
int |
Value indicating the transaction failover state (see Table 1-23) |
type |
int |
Value indicating the type of transaction (see Table 1-24) |
coordinator |
int |
Value indicating the coordination method or protocol (see Table 1-25) |
state |
int |
Value indicating the current state of the transaction (see Table 1-26) |
connection |
int |
Value indicating the connection state (see Table 1-27) |
status |
int |
Internal transaction status flag |
status2 |
int |
Additional internal transaction status flags. |
spid |
smallint |
Server process ID, or 0 if the process is detached |
masterdbid |
smallint |
Starting database of the transaction |
loid |
int |
Lock owner ID |
namelen |
smallint |
Length of “xactname” below |
xactname |
varchar(255) |
Transaction name or XID |
srvname |
varchar(30) |
Name of the remote server (null for local servers) |
failover value |
Failover state |
---|---|
0 |
Resident Tx |
1 |
Failed-over Tx |
2 |
Tx by Failover-Conn |
type value |
Transaction type |
---|---|
1 |
Local |
3 |
External |
98 |
Remote |
99 |
Dtx_State |
coordinator value |
Coordination method or protocol |
---|---|
0 |
None |
1 |
Syb2PC |
2 |
ASTC |
3 |
XA |
4 |
DTC |
state value |
Transaction state |
---|---|
1 |
Begun |
2 |
Done Command |
3 |
Done |
4 |
Prepared |
5 |
In Command |
6 |
In Abort Cmd |
7 |
Committed |
8 |
In Post Commit |
9 |
In Abort Tran |
10 |
In Abort Savept |
65537 |
Begun-Detached |
65538 |
Done Cmd-Detached |
65539 |
Done-Detached |
65540 |
Prepared-Detached |
65548 |
Heur Committed |
65549 |
Heur Rolledback |
connection value |
Connection state |
---|---|
1 |
Attached |
2 |
Detached |