deleting SXMSCLUP and SXMSCLUR / Quesiton on DEL flag in SXMSPMAST

[Former Member]

1) how can we delete entries out of these tables?

2) I defined retention periods and since then the msgs are being flagged for ARCH but the older msgs which were in the system before i defined retention period and scheduled the archiving and deletion jobs, are now marked with status DEL in SXMSPMAST.

Can someone help me on this on how to delete old msgs in the tables?

[Former Member]

Hi Tony,

Have you managed to solve the issue with the SXMSPMAST table? There is a SAP Note on this: https://service.sap.com/sap/support/notes/789352

Rgds,

Derek

Please award points if this solves your problem.

[Former Member]

Hi

I think for incorrect messages we can follow these steps:

1)A job to write the messages to the archive

2)A job to delete the archived message

Hope it helps

Regards

Arpit Seth

[former_member187339]

Hi Tony,

>> 1) how can we delete entries out of these tables?

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

Regards

Suraj

[Former Member]

hi suraj,

does this mean that all msgs in the cluster tables are the ones processed successfully.

if yes, then i can set them to delete before the 30 day limit via the tuning parameter PERSIST_DURATION = 5days.

does the above make sense?

thanks

tony

[former_member187339]

Hi Tony,

>>does this mean that all msgs in the cluster tables are the ones processed successfully.

No, cluster table contains all the message processing data. Messages that have been processed correctly are deleted by default(default retention period is 30 days).

Yes, u can set them to delete before the 30 day limit via the tuning parameter PERSIST_DURATION = 5days.

Hope this will be helpful.

Regards

Suraj

[Former Member]

suraj,

thanks for clearing that up. but how to the incorrect msgs get deleted out of the cluster tables.

tony

[former_member187339]

Hi Tony,

For deleting the incorrect messages from the cluster tables you have to schedule a job (deletion job). Before scheduling a job for deletion there are some prerequisites which should be met. Go thru this link and you doubts will be cleared :

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

Hope this will be helpful

Regards

Suraj