Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Cleanup of tables SXMSCLUP & SXMSCLUR

Currently the first table is was over 94 gig and we would like to delete all messages out of it before a certain date. I have tried running the different jobs but havn't been able to get more than 30 gig of messages out of it. How can I clean them up?

Former Member
Former Member replied

Hi,

You should run report "RSXMB_DEL_CLUST_TABLE" to delete entries from this two tables.

Yo need activate Archiving and Deletion Jobs.

To find the relevant jobs, call transaction SXMB_ADM and choose: Administration > Schedule Archiving Jobs

If you using BPM see this notes:

SAP Note 836092: Archiving/deleting work items in the XI

SAP Note 874708: BPE HT: Deleting message persistence data in SWFRXI*

Tables SXMSCLUP and SXMSCLUR Archiving

How to clean or delete

Messages that have been processed correctly are deleted by default. You must archive all messages that are not to be deleted.

For more info :

http://help.sap.com/saphelp_nw04/helpdata/en/0e/80553b4d53273de10000000a114084/frameset.htm

Refer this forum link this will help you

Tables SXMSCLUP and SXMSCLUR Archiving

Please reward points

Thanks

Vikranth

Edited by: Khimavath Vikranth on Jun 4, 2008 4:59 PM

Edited by: Khimavath Vikranth on Jun 4, 2008 5:00 PM

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question