How to delete sap pi xml messages without archive

[Former Member]

Hi Support,

I am using ECC6.0 with Solaris OS. We did not delete any PI XML messages from first day,now my database size growing by 1 TB and i am getting performance issue due to XML messages which is near about 90 lac.Now i want to delete all XML but for this activity i do not have enough space for run the job to archive first and then delete. So i need to delete XML directly without archive. OR please guide me any other method for delete  XML without using space for archive.

Also can any one help me that how many GB space required for delete 90 lac XML's.

I can arrange space for table space but very difficult  for archive.

Thank You,

Faizan.

[gagandeep_batra · Accepted solution]

Hi Faizan,

For deletion of large volume of data switch procedure is recommend

You can check following blog that may help

http://scn.sap.com/community/pi-and-soa-middleware/blog/2010/04/22/archiving-deletion-of-messages-in...

regards

GB

[Former Member · Accepted solution]

Hi Gagndeep,

Switch procedure is good option but for this activity also we are not having free space to switch XML's to another container.

Do you have any other idea which is not require space.

Thank You,

Faizan.

[gagandeep_batra · Accepted solution]

Hi Faizan

For directly deleting you don't need to archive first, just execute the delete job directly

Regards

GB

[Former Member · Accepted solution]

Hi Gagndeep,

I am not able to stop switch job in my PI system,

Do you know other method to stop switch job for delete XML's without archive?

Regards,

Faizan.

[gagandeep_batra · Accepted solution]

Hi Faizan,

did you try to uncheck the check box of switch procedure & save in

Path for this is: SXMB_ADM->Configure Delete Procedure->

Regards

GB

[Former Member · Accepted solution]

Hi Gagndeep,

I am trying this ...I saved after unchecked the switch check box , but ones i closing  and reopening it is becoming checked,

That is  only i am saying that  i am not able to stop the job... 

Any further Idea please????

Regards,

Faizan.

[gagandeep_batra · Accepted solution]

Hi Faizan

Then i think you need to check the following thread and follow the sap recommendation by

------------------------------

SAP recommended to perform the following steps in the given order

1) for the time being do NOT start job SAP_BC_XMB_DELETE_100

2) restart tables switch by

- running transaction SXMS_MONI_JOB

- press 'Reschedule Terminated Copy Job'

3) after switch has completed re-schedule job SAP_BC_XMB_DELETE_100

this will set as many messages as possible to status 'logically

deleted' and afterwards another run of the table switch is started;

as the

- switch procedure is not yet turned off and

- the fill level has exeeded the threshold

report RSXMB_TABLE_SWITCH will decide to actually perform the switch back from table copies to original tables;

as soon as this switchhas been performed successfully the switch procedure will turn off automaticall due to the notification flag that is already set.

--------------------------------------------------------------

  Re: How to Turn Switch Deletion Procedure to Simple Deletion Procedure

  

       NV Seshagiri  

Regards

GB

[josantonio_roldnluna]

Hi Faizan,

All messages in PI has stored in SXMSPMAST table. If you prefer run report RSTRFCQD for delete outbound messages and RSTRFCID to delete inbout messages.

But, you should confugure Archiving and deletion Procedures as Gagan suggest.

[Shabarish_Nair]

Refer the following notes for complete actions available for data management -

872388

49545

836092

1826133

[Former Member]

Hi

This document may help you

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0afdd69-a8a7-2d10-7e9a-cbf6fa21c...