topic Re: Data Archiving space calculation in Application Development and Automation Discussions

Data Archiving space calculation

Former Member — Mon, 07 Jan 2008 13:30:13 GMT

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.

Re: Data Archiving space calculation

Former Member — Mon, 07 Jan 2008 14:45:51 GMT

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

Re: Data Archiving space calculation

Former Member — Mon, 07 Jan 2008 15:08:07 GMT

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

Re: Data Archiving space calculation

Former Member — Mon, 07 Jan 2008 15:37:07 GMT

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

Re: Data Archiving space calculation

Former Member — Mon, 07 Jan 2008 16:45:28 GMT

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?

Re: Data Archiving space calculation

Former Member — Wed, 23 Jan 2008 09:43:16 GMT

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

Re: Data Archiving space calculation

Lakshmant1 — Wed, 23 Jan 2008 10:24:47 GMT

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

Re: Data Archiving space calculation

Former Member — Wed, 23 Jan 2008 11:50:04 GMT

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

Regards,

Priya.

Re: Data Archiving space calculation

Former Member — Wed, 23 Jan 2008 11:55:37 GMT

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

regards,

Priya.

Re: Data Archiving space calculation

Former Member — Wed, 23 Jan 2008 14:16:51 GMT

Hi Priya,

Use TA: SAR_DA_STAT_ANALYSIS to view the archiving statistics.

Cheers!

Samanjay