- 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
KBA , performance , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.