cancel
Showing results for 
Search instead for 
Did you mean: 

Archiving old SXI_MONITOR messages

EdgarsRD
Discoverer
0 Kudos

Hello wonderful people, I need some help.

We run a multi-client setup in SAP and are approaching our storage limit.
Checked DB02 and noticed that SXMSCLUR is take taking up a HEAP of disk space.

After going through various posts on this site as well as a few forums, I couldn't find a good answer for this -
I want to DELETE all messages in SXI_MONITOR, prior to 01.01.2022
Checked in the SXMB_ADMIN under archiving, but it does not allow me to select a specific date from which the messages could be deleted.

Am I missing something obvious?

View Entire Topic
mamartins
Active Contributor
0 Kudos

SAP have an ARCHIVE object already available to store the messages on disc and then delete them from the DB.

To configure it use the T-CODE "SARA" and the object name is "BC_XMB". The procedure (short list) is:

  • configure an external (local or remote) repository to store the files (T-CODE "FILE")
  • create job to export the messages to the repository
  • create job to delete from the DATABASE after successful export

Please look onto this link.