The spt_committab table in Adaptive Server stores information and tracks the completion status of each two-phase commit transaction. All activities made against spt_committab are logged. Prior to 11.5, spt_committab resided in the master database. However, the logging activity against spt_committab for two-phase commit transactions can fill up the master transaction log, causing frequent space management problems.
In release 11.5, the spt_committab table resides in a new system database called sybsystemdb, instead of the master database. Providing spt_committab its own database makes space management and recovery of two-phase commit transactions easier, for two reasons:
The dump tran command can be used against sybsystemdb.
Unlike the master database, the sybsystemdb database is extensible.
