2145275 - How to improve performance of incremental REORG? - ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

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

SAP Adaptive Server Enterprise 15.7

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.