sybsystemdb database only
syscoordinations contains information about remote Adaptive Servers participating in distributed transactions (remote participants) and their coordination states.
The columns for syscoordinations are:
Name |
Datatype |
Description |
|---|---|---|
participant |
smallint |
Participant ID |
starttime |
datetime |
Date the transaction started |
coordtype |
tinyint |
Value indicating the coordination method or protocol in the systransactions table definition |
owner |
tinyint |
Row owner (for internal use) |
protocol |
smallint |
Reserved for internal use |
state |
smallint |
Value indicating the current state of the remote participant (see Table 12-4) |
bootcount |
int |
Reserved for internal use |
dbid |
smallint |
Database ID at the start of the transaction. |
logvers |
tinyint |
Reserved for internal use |
spare |
smallint |
Reserved for internal use |
status |
tinyint |
Reserved for internal use |
xactkey |
binary(14) |
Unique Adaptive Server transaction key |
gtrid |
varchar(255) |
Global transaction ID for distributed transactions coordinated by Adaptive Server (reserved for internal use) |
partdata |
varbinary(255) |
Reserved for internal use |
srvname |
varchar(30) |
Name of local server (null for remote servers) |
Table 12-4 lists the values for the state column:
state value |
Participant state |
|---|---|
1 |
Begun |
4 |
Prepared |
7 |
Committed |
9 |
In Abort Tran |
