Skip to Content
avatar image
Former Member

DB/table/index reorg after archiving

Hi All,

I am starting this dicussion on reorg as it relates to Archiving.

Post archiving , it is recommended to do a reorg.

Usuallly it is done at table or index level by the DBA's /Basis teams.

following are some points for discussion .

1. what are the tasks of archiving team in the reorg activity and how can they help the DBA , Basis team on the reorg?

2. are there any real time examples that some one can share on a reorg task. it could be ex: FI_DOCUMNT archiving followed by reorg of the tables related to this object.

3. it is recommended that if the tables are expected to grow again , then reorg is not necessary , is it true?

4. best practice documents on reorg , available on SAP Service market place or somone can share other documents?

5. time taken for reorg on large tables . ususally during a maintenance window , (offline reorg).

any additional information that was missed above.

Please note this is not a list of questions, but a discussion to share work expriences around the reorg task.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 11, 2014 at 01:44 PM

    Hello,

    Well, this actually is a list of questions, but, they can all be answered by looking at oss note 541538.

    Best Regards,

    Karin Tillotson

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello again,

      When I archive a significant amount of data (for example 1 year of SD billing documents), I then let the Basis team know which tables were the most impacted and then they rebuild the relevant indexes. Table/tablespace reorgs are not as common and to my knowledge only done if you need to actually reduce the database size (as opposed to just freeing up space).

      Are you familiar with the document "Performance Aspects of Data Archiving"? This can be found out on the ILM Service Marketplace page under Data Archiving -> Media Library -> Literature & Brochures. It contains a lot of good information on this topic.

      Best Regards,

      Karin Tillotson