Process Chain Logs and Assigned Process Logs Deletion

 

Created by:	SAP
Underlying SAP report:	RSPC_LOG_DELETE
Client-dependent:	No
Settings as variant:	Yes
Support for RecycleBin:	No
Recommended for HANA pre-migration Housekeeping:	Yes

Introduction

Process chains are used in the BW landscape to automate the loading sequence. There are multiple running process chains at a given time. Their logs are stored in the database to be ready for future analysis. Storing older logs might use up disk space, and it is necessary to delete the older process chain execution log.
Process chains are executed at different frequencies – daily, weekly, monthly, on a specific calendar day, etc. The following tables store information about process chain logs: RSPCLOGCHAIN, RSPCPROCESSLOG.
The report RSPC_LOG_DELETE is designed to delete the process chain log.

Recommendation

Our recommendation is to delete process chain logs according to the process chain frequency of execution. In the case of daily or weekly execution, we recommend deleting logs older than 3 months. In the case of monthly or quarterly execution, we recommend deleting logs older than 6 months. Other frequencies are also possible as per individual requirements.