Archiving the database

[Former Member]

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

[Former Member]

answered

[Former Member]

answered

[Former Member]

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

[Former Member]

Hi Shamim,

Could let me know how to find the archiving object for one of the tables eg., "zinvaging".

Regards

Kiran

[fidel_vales]

Hi,

for the name, it looks like it is a customer table (not a SAP standard table)

I think you will not find an standard archiving object for it

[Former Member]

Hi fidel,

If i am looking for a archiving object for a standard table like "S001" where do i like for

i mean which T.code is use and can't we find archiving object for any "z" tables, do we have

to create or how to go about this.

Regards

KiranKumar.D

[Former Member]

Hi Kiran

To find archiving objects for particular tables, use transaction SARA -> Database Tables -> Archiving Objects -> enter tablename

There is no archiving object for table S001. Looks like some information structure, as far as i know they have their own deletion mechanism.

For Z-tables: they are customer tables and the customer has to take care of archiving / deletion himself.

Best regard

Michael

[former_member204746]

once you archive your data, you will need to reorg your tablespaces to reclaim disk space... until then, you disk will be as full, even after archiving. consider that.

[Former Member]

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

[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