Question:
Gurus
I want to delete the change log entries as we are facing the space problem
our BASIS admin analysed that change log is growing heavily accupying huge amount of spaces .
Before hitting the button i would liketo know what are the repurcussions of deleting the change log
your suggestions and inputs are welcome.
Answer:
Gurus
I want to delete the change log entries as we are facing the space problem
our BASIS admin analysed that change log is growing heavily accupying huge amount of spaces .
Before hitting the button i would liketo know what are the repurcussions of deleting the change log
your suggestions and inputs are welcome.
Hi
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:
1)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.
2)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".
3)Rebuilding of ODSR_... Requests
If you delete the Changelog then rebuilding from the Changelog is also no longer possible for the deleted requests
Hope it Helps
_________________
Chetan
@ CP...