Monitoring coordinated transactions and participants

Adaptive Server tracks information about the status of work done in subordinate servers using data in the new system table, sybsystemdbdbo.syscoordinations. See the Reference Manual: Tables for a complete definition of this table.

The sp_transactions procedure also displays some data from the syscoordinations table for in-progress, remote transactions. See “Getting information about distributed transactions” for more information.