Delete PSA Reqests for a Delta DataSource

[Former Member]

HI all

this is problem has been discussed in diff aspects in sdn , but my requirement is bit different, & here it is

I´m using Delta Infopackage to load to a Delta Capable DataSource, & then a Delta DTP for loading into a DSO. SInce it is a line item level information , the PSA occupying lot of space which i want to free up

1. Can i delete the PSA requests, without affecting the daily delta activities ?

2. If so , should i delete only the Delta Request only or can I del the INIT requests as well , as the INIT also occupies lot of space, as they were run with data transfer option.

3. Can I delete the Changelog table to free up some more space without affecting the daily delta activities. ?

Regards,

Ramesh

[Former Member · Accepted solution]

Some Insights-

<b>PSA - Delete</b> Yes you can delete the requests.

No, it does not affect the ability to determines delta because DTP determines the delta based on REQUEST. Before the PSA is regularly purged, ensure that all the requests are already updated into the data target.

<b>Change Log delete-</b>

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".

***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

Chetan

@CP..

[Former Member · Accepted solution]

Hi Chetan

1. Can i delete all my requests in the PSA including INIT ? or should i delete only Delta requests. ?

if so , can we automate the prcoess chain for deleting only Delta Requests only ?

2. in what scenarios would i need the rollback & reconstruction facilites ?

If I were not to use the old Delta Requests , then can i delete the Change log table ?

regards,

ramesh

[Former Member]

U can delete the PSA requests,if they are older than 15 days and u think they r not used for anymore for retrival once again.