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?
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 :
Refer this forum link this will help you
Please reward points
Edited by: Khimavath Vikranth on Jun 4, 2008 4:59 PM
Edited by: Khimavath Vikranth on Jun 4, 2008 5:00 PM