Cleanup of tables SXMSCLUP and SXMSCLUR

[anupam_ghosh2]

Hi Experts,

Need to reduce size of SXMSCLUP and SXMSCLUR tables by 60%-70%. I followed data archival followed by data deletion.

In acceptance server business wanted to have a message retention period of 30 days. Selected all interfaces for archival and scheduled archival followed by deletion process. After deletion I was able to achiev only 5% decrease in number of entries in the table. Have you achieved reducing the size of these tables by 60%- 70% .

Could you please kindly share your experience in this regard.

I have gone through many blogs, articles and threads in this matter. We are working with PI 7.0.

Regards

Anupam

[Former Member · Accepted solution]

Hi Anupam,

have you seen these threads ?

[http://forums.sdn.sap.com/thread.jspa?threadID=1848653]

[http://forums.sdn.sap.com/thread.jspa?threadID=321944] (see last post: option to be selected)

Mickael

[anupam_ghosh2 · Accepted solution]

Hi Mickael ,

Thank you so much for your kind response. I went through those threads earlier but I was unable to get good results. I have gone through many threads and articles in this regard. Thus I need some inputs from experts who have actually reduced the size of those tables.

Hi Experts,

Could you please share your views in this regard.

Thanks

Anupam

[Former Member · Accepted solution]

Hi,

You should run report "RSXMB_DEL_CLUST_TABLE" to delete entries from this

two tables. For mor information please read SAP Note 761713.

The procedure for scheduling deletion job is as follows.

1. Define retention periods which should be stored data in database.

2. Start transaction "SXMB_ADM"

3. Execute "Define Interfaces for Archiving and Retention Periods"

4. Click "Retention Period" button

5. Maintain retention periods.

Create deletion job

1 Start transaction "SXMB_ADM"

2 Execute "Schedule Delete Jobs"

3 Maintain start date, start time and period for each of jobs.

(It is necessary to schedule for XML Messages and History Entries).

regards,

ganesh

[Former Member · Accepted solution]

Hi ganesh,

I would like to know if this can be done in ECC/R3??

Thanks