Archiving

[Former Member]

SAP 4.7 6.20 Oracle 10g Windows Server 2003

We have SAP since 2005, and we are about to start implementing Archiving in our company.

This project will start in October, and its finish is not defined yet.

We know that the first time we execute the Archive procedure, a lot of rows will be moved from sap databases to another structure located in another server.

And we are thinking if it will be necessary to execute something, or some commands after this happens.

When these rows are deleted from sap tables, are we supposed to execute something in order to "fix" the tables ?

Eduardo

[former_member311580 · Accepted solution]

Hello Eduardo,

After a further archiving, supposing that you change the size of the tables by deleting a great volume; you can, first, save the released space by Reorganizing tables with BRSPACE; see note 646681 and relateds.

After, in order to maintain the DB performance, you should refresh the CBO statistics. Consider that the statistics are calculated in function of the size; when it changes we must re-calculate CBO statistics.

Ensure that CBO statistics are collected for SYSTEM DB and DB Dictionary for involved tables.

brconnect -u / -c -f stats -t oradict_stats

brconnect -u / -c -f stats -t system_stats

Please refer to attached oss note 838725 and its related subnotes.

838725 Oracle database 10g: New database statistics

863811 Using BRCONNECT to collect statistics for Oracle Dictionary

601395 Collecting system statistics with BRCONNECT

Regards,

Rafa

[JPReyes]

are we supposed to execute something in order to "fix" the tables ?

Tables do not need fixing... basically the data that has been deleted after archiving will not be reclaimed as empty space until a reorganization is done.

All the info you need is in SAP Note 646681

Regards

Juan

[ganesh_borase2]

Hi!

You have to maintain the retaintion period for each arching like PO, Material etc.

Then observer the How much space will free.

Please inform which Database you are using.

Thanks

Gnaesh

[Former Member]

Hi,

The most important task after a big amount of archiving is to rebuild the indexes of the tables where the deletions occurred.

Otherwise, the performance of the system will take a big hit...

Some times you even have to rebuild the indexes during the archiving process because otherwise the archiving programs become slower and slower.

Regards,

Olivier

[Former Member]

Hi,

As Rafa has suggested, you need to reorg the database to gain the space released as a result of your archiving and update the CBO.

Just to correct you one one of you statement.

"We know that the first time we execute the Archive procedure, a lot of rows will be moved from sap databases to another structure located in another server."

The archiving will write the selected amount of data as an flat file to an folder/directory as configured in your archive configuration, and not in another server, but on the same application server, may be a NFS. You have options to view the archive data, which needs these files to available for SAP.

Regards,

Sanujit