When you apply changes or content updates to the SLD (system landscape directory) in SAP, the change log grows.
It’s possible to see the change log entries from the SLD administrator page.
Due to this growth, the underlying database table will benefit from reorganisation at some point.
In our scenario, this was on DB2.
We decided to run the cleanup, but first here was the size of the table BC_SLD_CHANGELOG:
db2prd> db2 “SELECT TABNAME, NPAGES FROM SYSCAT.TABLES
ORDER BY NPAGES DESC”
TABNAME NPAGES
—————————- ——————–
BC_SLD_CHANGELOG 14162
BC_SLD_INST 12830
J2EE_CONFIGENTRY 5870
BC_SLD_ASSINST 3905
EP_ATTR_VALUES3 3082
J2EE_CONFIG 2163
DBH_STG_PKG_CACHE_METRICS 1421
SYSCOLDIST 1193
Then delete the change log in https://<server>/sld
Select “Administration -> Maintenance -> Clean Up Change Log -> Remove Entries”.
I then scheduled a standard job to do this work from the “Cleanup Task Configuration” tab.
Finally, reorg the following tables to release the space:
db2 “REORG INDEXES ALL FOR TABLE SAPPODDB.BC_SLD_CHANGELOG”
db2 “runstats on table SAPPODDB.BC_SLD_CHANGELOG AND INDEXES ALL”
db2 “SELECT TABNAME, NPAGES FROM SYSCAT.TABLES WHERE TABNAME = ‘BC_SLD_CHANGELOG'”
TABNAME NPAGES
—————————- ——————–
BC_SLD_CHANGELOG 1205
That’s it.