PSA Cleanup

Created by:	SNP
Client-dependent:	No
Settings as variant:	No
Support for RecycleBin:	Yes
Support for initial Housekeeping:	Yes
Recommended for HANA pre-migration housekeeping:	Yes
Pause/resume support:	Yes

Introduction

The PSA Cleanup is part of the Business Warehouse deletion tasks.
The Persistent Staging Area (PSA) is the inbound storage area in BI for data from the source system. Requested data is saved unchanged from the source system.
Requested data is stored in the transfer structure format in transparent, relational database tables in BI.
If regular deletion does not take place, data from PSA tables can grow to an unlimited size. In applications, this can lead to poor system performance, while from an administration point of view, it can cause an increase in the use of resources. High volumes of data can also have a considerable effect on the total cost of the ownership of a system.
In SNP Outboard™ Housekeeping, it is possible to delete data from PSA tables using a retention time.

Step List

1. In the main SNP Outboard™ Housekeeping menu, select Business Warehouse > Deletion Tasks PSA Cleanup and click Settings.
2. Specify your desired settings. You can create new settings by entering a new ID or choose from existing settings.

For more information on settings, refer to the Creating a settings ID chapter of this user documentation.

_scroll_external/attachments/worddavc98fdb18dee7b3639b7553940d181102-de47a77710a37e0c83f6b75031cc50eb340fb2a6ac4fbd1adb3a58e788028003.png

_{PSA Cleanup – Settings}

You can edit the created settings group. To save your changes, click Save Settings in the taskbar.

Step 1

1. You can specify the DataSource name(s) by clicking Add object.
2. From the list of available DataSources (F4), select which ones you want to add to the newly created settings group and then confirm your selection.
3. You can specify the source system as an additional filter for DataSources. The options Include and Exclude determine if the result of a selection will be added or removed from a selection.
4. You can set the DataSource name in a pattern style.
5. By selecting Do you want to save a pattern?, you can skip the selection of PSA tables. This is useful if you create settings at the group level.

_scroll_external/attachments/worddavbc452117f4fee1f52ce6e255277c41d4-13470a1c06d583f50faf64599ae2b4eb0bcc49a16a5cd47721c995f95a0ebcf0.png

_{PSA Cleanup – DataSource selection}

6. After confirming, select the PSA tables that you want to clean up and confirm your selection again.

The selected PSA tables will be added to the settings group list.

_scroll_external/attachments/worddav2456e47a5cff62bb6671c8400a760937-297035a48e4ff9e267c2207f64eb21a3cd789d01957df85481d13c904c623411.png

_{PSA Cleanup – PSA selection}

_scroll_external/attachments/worddavcc3c690b084a49b474f9e596ac5b80e6-598bdc2d604ab33fcf415fbccd702dd79fbc0de52df2e5acabc77b006e3bdefa.png

_{PSA Cleanup – Settings with patterns and objects}

Icons in the X column indicate how the lines will apply to the overall list of PSAs:

_scroll_external/attachments/worddav5e8fb89c7710c4a2119043bc0b1bcb06-c014e2bc2ca338584753a0e6dbb57c35126fb9af7c94141baf40cf0c254c3b4a.png The pattern will be evaluated during the task execution, and the PSAs will be added to the overall list.
The pattern will be evaluated during the task execution, and the PSAs will be removed from the overall list.
_scroll_external/attachments/worddav21fc442754602cae38d6f871ff97b3ff-ecb5f0b0df2f60f2ca546abd777459f6e69f974edd9a2d5c8861462f2ddfdae9.png The PSA will be added to the overall list.
The PSA will be removed from the overall list.

If the pattern is added, you can click its technical name to display an evaluation of the pattern and show the list of PSAs.

_scroll_external/attachments/worddav29f12c3d1e13ab435e756d9ce5cc2936-ea44e7a37b38ab7fc6bcd83133098aca5b77eb2b15844543d72a9161599b8e00.png

_{PSA Cleanup – List of PSAs included in the pattern}

Step 2

By clicking Select requests, you can specify the time period for the deletion of relevant entries in selected PSA tables and exclude/include the requests with an error or archiving status from the processing. From SNP Outboard™ Housekeeping version 2.54, there is an option that enables the direct deletion of PSA tables by skipping the RecycleBin use.

NOTE You can specify different time criteria for every PSA table in the list. If no selection on the PSA table is made, the selected time parameter will be set for all PSA tables in the list.

_scroll_external/attachments/image2019-6-7_14-49-46-0fb02e5631a5341f12269e790383fb9ebfeb46ba3edf6c41cf8b69c6aa95c61c.png

_{PSA Cleanup – Time period settings}

Step 3

Test Run for settings: This run builds the overall list of PSAs, scans them and identifies all request IDs that fulfill the Time period condition. After Test Run execution, the screen Requests to be deleted opens with a list of relevant request IDs, DataSources and source systems.

_scroll_external/attachments/worddavec7eb1358b3c4375274caff685599a23-79d0ddb0d30d6c07b0abfce6c204cfc981d5eba2ec18eb50da81117cfb11ff14.png

_{PSA Cleanup – Test run result}

NOTE If the settings are created at the group level, the Test Run button is unavailable and therefore this step is skipped.

Step 4

The next step is to set the time limit for the RecycleBin. Enter the value in days in the RecycleBin Period field or leave the default value, which is 14 days.

NOTE Data stored in the RecycleBin is still available and can be restored if necessary during the time period that was defined during the setup. Once the time period expires, data stored in the RecycleBin will be automatically deleted by manual or scheduled execution of the system task RecycleBin Cleanup.

_scroll_external/attachments/worddavfdcb8d4247925e11a57ecab46eb4620e-5248abbcb0a0d270d9fe894b0b2a5859c60cdbb27ac055d94f831ab388e98e2e.png

_{PSA Cleanup – RecycleBin Period}

Step 5

You can define the maximum number of jobs that can run in parallel by using the input field Max. jobs on the right-hand side.

NOTE If the parallelization parameter Max. jobs is set to 0, the execution of such settings will distribute the selection into particular execution blocks. However, the execution of these blocks will not be performed, and the respective run ID will be paused.

_scroll_external/attachments/worddav79451c1eeb02234f0d4b626db9a4782b-e0ec940aa9640d682cd246fad39b3385061e71267bf118641559985160607f08.png

_{PSA Cleanup – Parallelization – Max. jobs}

Once the settings for the task PSA Cleanup have been specified, you can run the created/modified settings group from the main menu. There are several options for starting the deletion. For more information, refer to the Executing and Scheduling Activities chapter of this user documentation.

You should specify the settings ID when executing/scheduling the activity.
To check the status of the run, you can go to the monitor or check the logs.

Recommendation

We recommend periodically deleting the following requests:

All incorrect requests
All delta requests that have been updated successfully in an InfoProvider and for which no further deltas should be loaded.

It helps to reduce the database disk space usage significantly. Our recommended retention time for PSA tables is 15 days. The task should run daily in general, but this frequency is application-specific.