Applies to master database only. systransactions contains information about SAP ASE 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 SAP ASE transaction key |
starttime |
datetime |
Date the transaction started |
failover |
int |
Value indicating the transaction failover state. Valid values are:
|
type |
int |
Value indicating the type of transaction. Valid values are:
|
coordinator |
int |
Value indicating the coordination method or protocol. Valid values are:
|
state |
int |
Value indicating the current state of the transaction. |
connection |
int |
Value indicating the connection state. The connection values and
states are:
|
status |
int |
Internal transaction status flag |
status2 |
int |
Additional internal transaction status flags |
spid |
smallint int for the Cluster Edition |
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 |
xactname |
varchar(255) null |
Transaction name or XID |
srvname |
varchar(30) null |
Name of the remote server (null for local servers) |
nodeid |
tinyint null |
Reserved for future use (not available for cluster environments) |
instanceid |
tinyint |
ID of the instance (available only for cluster environments) |
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 |