Required to Delete the Messages from SXMB_MONI-- Older than 7 Days

[Former Member]

Hi All,

I want to just delete the Messages older than 7 days every time those were processed from MONI to keep my DB as free, don't want to Archive any thing.

I have gone through many blogs and articles, but there it is mentioned that we need to carry out these from SXMB_ADM

1) Define Interfaces for Archiving and Retention Periods

2) Schedule Archiving Job

3) Schedule Delete Jobs

4) Configure Delete Procedure

Do i really require all these if i just want for deletion???

Regards

[Former Member]

> I have gone through many blogs and articles, but there it is mentioned that we need to carry out these from SXMB_ADM

>

> 1) Define Interfaces for Archiving and Retention Periods

> 2) Schedule Archiving Job

> 3) Schedule Delete Jobs

> 4) Configure Delete Procedure

You cannot delete the messages directly. You have to perform the above steps.

> Do i really require all these if i just want for deletion???

Yes!

[Former Member]

Hi,

If i configure Archive and Delete Steps, where these messages will be Archived??

And also do i need to configure Delete Procedure step in this??

Regards

[Former Member]

I suggest to go through the pdf link to understand the process..

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/402fae48-0601-0010-3088-85c46a236...

[Former Member]

The Document which u have suggested is not talking abt XI

Regards

[Former Member]

Hi Sarvesh,

In this document it is saying that we need to create Logical Path on File server to Archive the messages which is i dont want.

Please summarize in brief to delete the messages and to reduce the DB usage

Regards

[former_member181962]

It IS talking about XI Only.

Why do you think it is not talking about XI?

Regards,

Ravi

[former_member181962]

Hi vamsi,

Archiving is a very important task with respect to SOX Compliance.

It is mandatory in some cases that you have to archive.

It doesn't get stored in any database if you are under such an assumption.

It gets stored on a file system only.

Regards,

Ravi Kanth Talagana

[Former Member]

Hi Ravi,

>>It is mandatory in some cases that you have to archive.

I have other archive process for each and every messages

>>It doesn't get stored in any database if you are under such an assumption.

>>It gets stored on a file system only.

I dont want to store any message on file system, because we dont require this

Please suggest me some other way with out using any file system to archive and with out storing it any where i need to delete those

Regards

Vamsi

Edited by: Vamsi Krishna on May 18, 2010 6:49 PM

[Former Member]

> I dont want to store any message on file system, because we dont require this

You have to use file system there is no other way. May be you can delete the messages later from file system.

>

> Please suggest me some other way with out using any file system to archive and with out storing it any where i need to delete those

I guess the best ans only SAP can provide you. Deleting the data directly without archiving is not possible and neither recommended.

[ravi_raman2]

@Sarvesh,

I disagree..

1) You can archive and delete ==> SAP Suggested option.

2) Delete w/o Archiving

SO you Can delete without Archiving.

Regards

Ravi Raman

[Former Member]

> 2) Delete w/o Archiving

>

> SO you Can delete without Archiving.

Ravi,

May be I am wrong or not aware of it ... Can you provide some SAP link or Blog which talks about Delete w/o Archiving.

Thanks!

[Former Member]

Hi Ravi,

Could you pls let me know the process for this

Regards

[Former Member]

Hi all,

We can delete with out Archiving when the messages are in success state using the report RSXMB_DELETE_MESSAGES

If you have messages in error, then u need to first cancel them then Archive with report RSXMB_ARCHIVE_MESSAGES

While archiving, the archived file will be created at E:\usr\sap\<SID>\SYS\global\

and we can manually delete them from that location.

then to delete the messages from MONI run the report RSXMB_DELETE_ARCHIVED_MESSAGES

Regards

[Former Member]

Please brief me steps to just delete the messages with out Archive

Regards