The sybsystemdb database stores information about distributed transactions. Adaptive Server versions 12.0 and later can provide transaction coordination services for transactions that are propagated to remote servers using remote procedure calls (RPCs) or Component Integration System (CIS). Information about remote servers participating in distributed transactions is stored in the syscoordinations table.
Distributed transaction management (DTM) services are
available in Adaptive Server version 12.0 and later as a separately
licensed feature. You must purchase and install a Distributed Transaction
Management license before you can use DTM services. See Using
Adaptive Server Distributed Transaction Management Features and
the installation guide.
The sybsystemdb database also stores information about SYB2PC transactions that use the Sybase two-phase commit protocol. The spt_committab table, which stores information about and tracks the completion status of each two-phase commit transaction, is stored in the sybsystemdb database.
See the Configuration Guide for your platform for information about two-phase commit transactions and how to create the sybsystemdb database.
