Data Archiving space calculation

[Former Member]

Hi ,

How to estimate the space saved by archiving an object?

Do we need to take the record counts of the related tables?

Thanks,

Priya.

[Former Member]

Hi Priya,

Checkout the following link.

[Space gained by Archiving|http://help.sap.com/saphelp_erp2005vp/helpdata/en/8d/3e4e26462a11d189000000e8323d3a/content.htm]

Hope this helps

Cheers!

Samanjay

[Former Member]

Thanks Samanjay for the help.But I am still not clear....

[Former Member]

Hi Priya,

Basically this is what you need to do.

Find the size of individual record by adding the size of each table that constitute the archive object. Ex: 1 MB

Find the total number of records available. Ex: 10000 records

No of records expected to be archived. Ex: 7000 records

Space gained by archiving ~ Record size * No of records expected to be archived

Ex: Space gained ~ 1 MB * 7000 ~ 7 GB

This is how one can find a rough estimate of space gained by archiving. It is not really possible to give exact figures when it come to space freed by archiving.

Hope this helps.

Cheers!

Samanjay

[Former Member]

Samanjay,could you please explain me

1.how to calculate the individual record size?

2.total archived records can be found from spool list of the archiving jobs.but is it necessary to take record counts from se16 or taana?

[Former Member]

Hi Priya,

There's one more way to find out the space benefited to the SAP system after the archiving runs.

You can follow the below steps to analyz the gained space:

1. Go to the transaction SARA

2. Click on Statistics

3. You can pass the active archiving objects on the selection screen which you have used during launching the archiving jobs.

4. You can also pass the date range considering the data on which you have run the archiving jobs.

5. Keep the status only Complete

6. Now execute i.e. display the statistics

7. In the final report, have a look on the Total for the DB space Deleted, Keep in mind that we have DB space write and DB space delete..db space deleted space will tell you the space you have freed up from the SAP R/3 database i.e. this much space gained after running the archiving runs.

Let me know if this helps u..

Regards,

Shamim

[Former Member]

Thank you Shamim. But I do not see 'Statistic' button in the initial screen of SARA. We are using 4.6C.

Regards,

Priya.

[Former Member]

Hi Priya,

Use TA: SAR_DA_STAT_ANALYSIS to view the archiving statistics.

Cheers!

Samanjay

[Lakshmant1]

Hi Priya,

For each of the tables related to archive object,

use FM GET_TABLE_SIZE_ALL or GET_TABSIZE to retrive the size and then calculate the estimate space.

Hope this helps.

Thanks

Lakshman

[Former Member]

Thankyou Lakshman. I will try this FM n let you know.

regards,

Priya.