SAP Knowledge Base Article - Preview

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 15.7


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.