Cleanup of tables SXMSCLUP & SXMSCLUR

[former_member220077]

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 · Accepted solution]

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*

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

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