Forgetting heuristically completed transactions  Completing transactions that are not prepared

Chapter 4: DTM Administration and Troubleshooting

Manually clearing the commit status

dbcc forget_xact purges the commit status of a heuristically completed transaction from systransactions. It can be used when the System Administrator does not want the coordinating service to have knowledge that a transaction was heuristically completed, or when an external coordinator will not be available to clear information from systransactions.

See dbcc in the Reference Manual for more information about using dbcc forget_xact.





Copyright © 2005. Sybase Inc. All rights reserved. Completing transactions that are not prepared

View this book as PDF