Skip to Content
avatar image
Former Member

Switch or Simple procedure to Delete the job?

Hi

I want to delete all the data which are less than 6 months I have changed the staus from del to arch for those data which need to archived .I am really confused on selecting the delete procedure whether to select simple or switch

in my data base there are more than 500000 to be delete

The simple deletion procedure deletes all XML messages flagged for deletion or archiving from the database tables in records.

it is saying will delete all the records which are flagged for archiving also

in switch it is taking copy of the table to another i want to reduce the space from my data base

Kindly suggest me how can i achive my goal

Thanks

Jayaraman

Edited by: Jayaraman P on Jun 21, 2010 4:05 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 21, 2010 at 02:52 PM

    Hi,

    Messages having status ARCH will not be deleted by the deletion job. only the messages having status DEL will be deleted by deletion job RSXMB_DELETE_MESSAGES.

    This message status can be checked by the status of ITFACTION of SXMSPMAST table.

    The type of deletion procedure simple or table swith has no effect on the messages that will be selected for deletion.

    The messages that has the flag ARCH can be deleted only by the ARCHIVE job. Archive job has two steps it first archive those messages in to file system RSXMB_ARCHIVE_MESSAGE and then delete by RSXMB_DELETE_ARCHIVED_MESSAGES.

    Please check the note Note 872388 - Troubleshooting Archiving and Deletion in PI for further assistance.

    Thanks,

    Francis

    Edited by: Francis M. A. on Jun 21, 2010 5:13 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      Thanks for your reply

      But in sap help it is mentioned like this

      Simple Deletion Procedure

      The simple deletion procedure deletes all XML messages flagged for deletion or archiving from the database tables in records.

      This procedure is recommended when small volumes of XML messages are to be processed by the Integration Engine. However, large data volumes have an adverse effect on performance during the deletion process. For this reason, the switch procedure is recommended when processing large volumes of messages.

      Thats what really confused me .

      Thanks

      Jayaraman

  • avatar image
    Former Member
    Jun 22, 2011 at 11:47 AM

    Thanks

    Add comment
    10|10000 characters needed characters exceeded