Adaptive Server 12.5.2 includes the 1pc parameter to the dbcc complete_xact command. 1pc heuristically completes a transaction that was subject to a one-phase commit protocol optimization—instead of the regular two-phase commit protocol—by the external transaction manager that was coordinating its completion. Heuristically committing such a transaction requires that the transaction is in a “done” state (as reported by sp_transactions).
The partial syntax for dbcc complete_xact is:
dbcc complete_xact("<xid>", "commit", "1pc")
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
