Messages Archiving & Deletion issu
I am facing an issue with archiving & deletion of XML messages.
when i check in the table SXMSPMAST the ITfaction=DEL for 42 Laks messages, when i run the delete job it is deleted few messages and finished immediately. after this i have activated "switch procedure" then i scheduled the Delete job again and it has taken long time to complete and around 35lak messages are copied into another table SXMSPMAST2.
again after scheduling the job it is again started coping the messages from table SXMSPMAST2 to SXMSPMAST,
when i run the reorg status job still the job is displaying number messages in data base is 42 laks.
can any body me what exactely happening here and how can i delete the messages that is copied into the table SXMXPMAST2.
Thanks in Advance