Symptom
- 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>'.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7
Product
Keywords
KBA , performance , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.