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 Adaptive Server Reference Manual 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.