syscoordinations

Applies to sybsystemdb Database Only. syscoordinations contains information about remote SAP ASE servers participating in distributed transactions (remote participants) and their coordination states.

Columns

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: 1 – Begun 4 – Prepared 7 – Commited 9 – In AbortTrans
`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 SAP ASE transaction key
`gtrid`	`varchar(255) null`	Global transaction ID for distributed transactions coordinated by the SAP ASE 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

Indexes

Unique clustered index on xactkey, participant, owner