Deleteing messages with status 003 in persistence layer

[Former Member]

Dear All

my XI DB is getting bigger and i have found that after running the report RSXMB_SHOW_STATUS , it has Message Status: 003 Number: 5.400.374 messages in DB .. my question is how can i delete theese messages from XI ? what need to be done after delting theese from DB ? will reorg is sufficint ?

apprciate your urgent sujestion in deleteing status 003 (5.400.374) messages permently from the DB ( please see the extract from the report also)

Regards

Buddhike

-

---

Number of Messages in Database:

6.180.784

Number of Messages in Client:

6.180.864

Number of Messages for Reorganization in Client:

6.180.927

Number of Messages to Be Archived in Client:

182.896

Number of Logically Deleted Messages in Client:

0

Number of Archived and Logically Deleted Messages in Client:

0

Message Status

==============

Message Status: 001 Number: 28.971

Message Status: 002 Number: 0

Message Status: 003 Number: 5.400.374

[Former Member]

Hi Buddhike,

To me it looks like you are missing setup of archiving/deletion of messages in the SAP PI system.

Please refer to these:

http://help.sap.com/saphelp_nw04s/helpdata/en/f5/d347ddec72274ca2abb0d7682c800b/frameset.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/41/b715015ffc11d5b3ea0050da403d6a/frameset.htm

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

Best regards,

Jacob