2145275 - How to improve performance of incremental REORG? - ASE

• Using incremental reorg to defragment large tables
• There is insufficient free space in the server to run regular reorg rebuilds on
• Incremental reorg takes hours to complete.
• Excerpts from the log

Resuming REORG DEFRAG of '<tablename>' partition '<partition_name>'.
Using time limit of 300 minutes.
Examined 524 allocation unit(s). Processed 116360 pages out of 1163558
data pages. 10% completed, resulting in 53% space compaction.
Examined 1048 allocation unit(s). Processed 232716 pages out of 1163562
data pages. 20% completed, resulting in 48% space compaction.
Examined 1666 allocation unit(s). Processed 349075 pages out of 1163561
data pages. 30% completed, resulting in 47% space compaction.
Elapsed time 5h : 0m : 0s : 458ms.
REORG DEFRAG of '<tablename>' reached the time limit of 300 minutes while
processing partition '<partition_name>'.

• SAP Adaptive Server Enterprise (ASE) 15.7
• SAP Adaptive Server Enterprise (ASE) 16.0

performance, reorg, defrag, cache , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem