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 |
int |
Value indicating the current state of the remote participant:
|
bootcount |
int |
Reserved for internal use |
dbid |
smallint |
Database ID at the start of the transaction. |
logvers |
tinyint |
Reserved for internal use |
spare |
tinyint |
Reserved for internal use |
status |
int |
Reserved for internal use |
xactkey |
binary(14) |
Unique Adaptive Server transaction key |
gtrid |
varchar(255) null |
Global transaction ID for distributed transactions coordinated by Adaptive Server (reserved for internal use) |
partdata |
varbinary(255) null |
Reserved for internal use |
srvname |
varchar(30) null |
Name of local server (null for remote servers) |
nodeid |
tinyint null |
Not available for non-cluster environments – reserved for future use |
instanceid |
tinyint |
Cluster environments only – ID of the instance |
Unique clustered index on xactkey, participant, owner
