Transactions coordinated by Adaptive Server or X/Open XA  Heuristically completing transactions

Chapter 4: DTM Administration and Troubleshooting

Transactions coordinated with SYB2PC

Prepared transactions that were coordinated using the SYB2PC protocol are rolled forward or backward depending on the commit status of the master transaction. During recovery, Adaptive Server initiates contact with the commit service to determine the commit status of the master transaction, and commits or rolls back the prepared transaction accordingly. If it cannot contact the commit service, Adaptive Server does not bring the database online. However, Adaptive Server does proceed to recover other databases in the system.

This recovery method was used for SYB2PC transactions in earlier Adaptive Server versions and is unchanged with Adaptive Server version 12.5 and later.





Copyright © 2005. Sybase Inc. All rights reserved. Heuristically completing transactions

View this book as PDF