cancel
Showing results for 
Search instead for 
Did you mean: 

Advice on Reducing DHCDC_RTSTORE Table Size in S/4HANA

SCN
Explorer
0 Kudos
369

Good day everyone,

We are currently consuming SAP business content in our Datasphere environment, with data being replicated from our on-premise S/4HANA system via replication flows.

Today, my SAP Basis team informed me that the DHCDC_RTSTORE table in S/4HANA has significantly increased in size. They have asked if there's a way to clean up or reduce the space used by this table.

Does anyone have experience or suggestions on how to handle this?

Thank you in advance for your help

SCN_0-1727818529895.png

 

SAP Datasphere 

View Entire Topic
n_gaertner
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello,

1. please check how many records are in DHCDC_RTSTORE
Note that the table is changing rapidly, and it could be that the table is not containing many records and therefore needs to be shrinked on DB level to free disk space - your DBA should know how to do it.

2. if there are many old records, check if there are hanging subscriptions and that your rentention periods are set properly - inactive subscriptions (including data) should be automatically deleted after the rentention.
See Note https://me.sap.com/notes/3088317/E for more information.

3. If you are unsure about the above tasks please open a ticket.

DO NOT delete the manually data using SQL (as adviced before), without explicit ask from the support team!