Automatically aborting or suspending processes  Waking suspended processes

Chapter 15: Managing Free Space with Thresholds

Using abort tran on log full to abort transactions

To configure the last-chance threshold to automatically abort open transactions, rather than suspend them, enter:

sp_dboption database_name "abort tran on log full", true

If you upgrade from an earlier version of Adaptive Server, the newly upgraded server retains the abort tran on log full setting.





Copyright © 2005. Sybase Inc. All rights reserved. Waking suspended processes

View this book as PDF