The two-phase commit protocol allows client applications to coordinate transaction updates across two or more Adaptive Servers and treats those transactions as a single transaction. Two-phase commit guarantees that either all or none of the databases in the participating Adaptive Servers are updated.
The enhancements to two-phase commit are:
Improved space and log management – The spt_committab table has been moved from the master database to a new system database, sybsystemdb.
Improved performance – You can use a random value for the commit identifier—commid.
