granularity of reorg operations in Sybase ASE

the way reorg is currently is designed is that it operates as a single transaction.  That means, all the work that reorg does is undone if the log is filled up (or any other error) and no space is available to extend the log.

Feature request #1 (design bug):

The granularity of all the reorg operations must be significantly increased.  Perhaps at the X number of extents, consider that a ‘sub tran’ that will be committed even if the rest of the reorg fails due to space or other ‘non-critical’ issue.


Share Button

Leave a Reply

Your email address will not be published. Required fields are marked *