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. 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 (see Table 1-28) |
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 |
Server process ID, or 0 if the process is detached |
int for the Cluster Edition |
||
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) |
Because of this change in the datatypes for the Cluster
Edition, Sybase strongly recommends that you archive and truncate
audit tables before you upgrade. This reduces the likelihood of
a failed upgrade because of insufficient space in the sybsecurity database.
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 |
