SAP SLD Change Log Housekeeping (BC_SLD_CHANGELOG)
SAP SLD i.e. System Landscape Directory is a key system in any SAP landscape. It is the central provider of landscape information in the SAP system landscape. Systems report their data, automatically updating their data regularly in the SLD. These updates are tracked as change logs in SLD.
But due to this regular updates into SLD from all system across landscape, the table BC_SLD_CHANGELOG can grow big in size. In some cases it may be the top table with size in SLD system. Hence to keep its size in control, regular cleanup of SLD change logs is recommended.
Change Log Cleanup
To perform the change log cleanup, follow below steps.
- Login to SLD, http(s)://<host>:<port>/sld
- In the SLD UI, choose Administration -> Changes -> Administrate Change Log
- Under Remove Entries older than, select a date from the drop-down calendar
- Click on Count to get exact number of entries which will get deleted as per selected date
- Once you are satisfied with selection, click on Remove Entries
Note : Do not delete entries still needed for incremental exports. If incremental export data are affected by your deletion, follow the system warnings. Also do not try to do deletion for very long range with high count, as it may halt your System.
Periodic Changelog Cleanup Task
You can also set the periodic task to delete change log.
- Login to SLD, http(s)://<host>:<port>/sld
- In the SLD UI, choose Administration -> Changes -> Cleanup Task Configuration
- If no task is scheduled, click on Schedule Task
- On next screen, enter Interval in Hours for periodic run, Click Next
- On next Screen, enter number of days beyond which entries to be deleted, then click Finish
This will create task Changelog Cleanup Task in JAVA Scheduler.
Reference SAP Notes
- 1792134 – Table BC_SLD_CHANGELOG Overflow
- 1840184 – Features which relies on the SLD change log
- 1799613 – SLD Change Log clean up tool