Skip to Content

Deleting PSA tables

Hello,

I would like to delete some ODS PSA tables in production in order to release disk space.

Is there any major risk in deleting a PSA table that loads a delta ODS? Do we loose any future delta load reference in the ODS change log table?

Thank you.

Regards,

Alex

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 25, 2004 at 09:19 AM

    Hi Alexandra,

    the only risk is, in case of a reload of your ODS-Objects, you need to reload from the source system instead of reloading from PSA.

    regards

    Siggi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 25, 2004 at 09:20 AM

    Hi Alex !

    Deleting PSA doesn't affect delta mechanism (you have to do other considerations about the availability of your data in a 'back-up' place..)

    Instead, changelog management is very critical for delta.

    Changelogs help to make ODS DataSources delta capable and are stored as a PSA table (indeed the Changelog is the PSA-Table of the Export-DataSource of the ODS !)

    Deleting data from the Changelog of an ODS object is allowed if these requests, which are no longer required for the delta update and also are no longer used for an initialization from the Changelog, have already been loaded into further DataTargets.

    Since the Changelog data can become extremely large, you may want to reduce the amount of data volume and delete data for a specific period of time as part of your data management strategy. As your ODS objects grow, Changelog files also grow (approximately by a factor 2). It is recommended to retain temporary, limited history according to your business needs.

    Note: Deciding not to purge Changelogs files before an upgrade can have a negative impact on the runtime of the Alpha Conversion phase. Runtime of the upgrade can increase because the conversion process has to read all ODS objects along with their associated Changelogs.

    Points to be Aware of Before Deleting Changelogs:

    ***You cannot reprocess old delta requests

    Once you delete Changelogs, the PSA request (ODSR_... requests), which are generated in the PSA when the request is activated in the ODS and contains the delta information, will no longer exist. Therefore, you will not be able to reload any old delta requests that are associated with the Changelogs which were removed from the system.

    ***New data targets cannot be built from the change log If Changelogs do not exist, new data targets can be created but will be built from the ACTIVE table using "FULL Upload" method but it is not recommended because this option has not gone through a complete testing cycle. Therefore, SAP cannot 100% guarantee the integrity of the data in all data loading scenarios.

    ***Rebuilding of ODSR_... Requests

    If you delete the Changelog then rebuilding from the Changelog is also no longer possible for the deleted requests.

    ***You can no longer rollback the activated requests from the ODS object

    Hope it helps !

    Bye,

    Roberto

    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.