Skip to Content
author's profile photo Former Member
Former Member

Archiving the database

Hi everyone

My production server hard disks are full.

I have no space left in it. I need to archive some

data so that i can free up space.

I know that archiving can be done through

SARA T.code.But not very sure how to be

done.

Can some tell me the process of doing it in detail.

step-by-step approach.

Regards

KiranKumar.D

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 03, 2008 at 09:28 AM

    Before archiving check why you re out of space.

    In many cases technical tables becomes very large (like TST03, BALDAT,IDOC tables)

    So first check this tables. If it is required delete theit content (according to relevant SAP notes) or reorganise them.

    Archiving is apllication consultant task. Before archiving contact business users to check whether you can archive data - the can be required for reporting or due to the legal requirements.

    Some helpful links :

    [http://www.sap-basis-abap.com/sapta009.htm]

    [http://www.thespot4sap.com/Articles/SAP_Data_Archiving_Support_Tools.asp]

    [Archiving Processed IDocs|http://sap.ittoolbox.com/documents/popular-q-and-a/archiving-processed-idocs-2884]

    regards,

    Wojtek

    reward points if helpful

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Wojtek,

      Archiving is a big task in itself. However my question is if i delete the

      content from the table and reorganise the tables will it not create

      free blocks in the database.

      I think that is what happening with my database, though i have freespace

      in the tablespace it is not able to allocate memory to one particular

      table itself. I think it is not able to allocate memory because space is

      non contigeous.

      Kindly suggest.

      Note : " I HAVE THE OPTION OF DELETING DATA FROM THE TABLES

      DATA IS NOT IMPORTANT FOR ME SPACE IS MORE CRITICAL ".

      Regards

      Kiran

  • author's profile photo Former Member
    Former Member
    Posted on Apr 04, 2008 at 07:29 AM

    Hi,

    I've gone through issue and it sounds to be interesting..!

    In this case, you can do the archiving using the transaction SARA as you know. However, before jumping into archiving your SAP data, you have to find out the list of tables which you want to archive.

    Once you have all the tables(independent and dependent tables) collected from different departments, you have to find out the archiving objects to which these tables belongs to.

    Once you are done with this, you can either launch the archiving jobs manually or automatically using the same transaction.

    In the transaction AOBJ, you will find the list of programs(Preprocessing, Write, delete etc etc).

    Note: The programs varies from one archiving object to other.

    The two major tasks you need to do are:

    1. Create Archive files using the Write program

    2. Delete the archive files using the delete program

    Yes, you have to create the variants for the write/delete programs in the tranaction SARA or SE38.

    First, in the tranaction SARA, enter the archiving object

    Click on the write button

    Pass the variant name, start date, spool parameters

    launch the archiving jobs

    Here, archive files will be created.

    Then click on delete button, select the created archive files

    Pass the start date

    launch the delete jobs

    The data as per your variants will be archived.

    Now, if you want to check the amount of space deleted from sap database after archiving, you can check the statistics.

    Look at the DB space (Delete) column, the size shown there will tell you the amount of space deleted in MB from ur sap database.

    I think this has answered ur questions.

    Regards,

    Shamim

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2009 at 05:46 AM

    answered

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2009 at 05:46 AM

    answered

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.