Deleting XI messages

[Former Member]

Hi,

Can someone please help me with deleting XI messages?

I have scheduled the deletion jobs for XI messages using the transaction SXMB_ADM and specified the retention period as 1 day for asynchronous messages.

´The job has successfully deleted some of the messages.

However, if I run the report RSXMB_SHOW_REORG_STATUS I see the following status:

Reorganization Status of XI Messages in the Database

Overview

=========

Retention periods and message and adapter status ignored in the following

Number of messages in DB: 45.906

Number of messages in client: 45.906

Number of messages in client still to be reorganized: 45.906

Archiving

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

Number of messages to be flagged for archiving

Message and adapter status is ignored in the following

- Msgs not in retention period (can be archived): 1

- Msgs in retention period (cannot be archived): 21

Message and adapter status is considered in the following

- Messages to be flagged for archiving: 0

Number of messages already flagged for archiving

- Messages to be archived: 0

Number of archived messages that can now be deleted

- Messages to be deleted: 0

Delete

=======

Number of messages to be flagged for deletion

Message and adapter status is ignored in the following

- Asynchr. msgs not in retention period (can be deleted): 45.508

- Asynchr. msgs in retention period (cannot be deleted): 376

Message and adapter status is considered in the following

- Asynchronous messages without errors to be flagged: 0

Message and adapter status is ignored in the following

- Synchr. msgs not in retention period (can be deleted): 0

- Synchr. msgs in retention period (cannot be deleted): 0

Message and adapter status is considered in the following

- Synchronous messages without errors to be flagged: 0

- Synchronous messages with errors to be flagged: 0

Number of messages already flagged for deletion

- Messages to be deleted: 0

I want to delete all the messages currently in the DB. Can someone help me with this please?

Thanks.

[Former Member]

Hi

I am also facing the same proiblem . When i select the program ,,, its showing around 400688. How to delete this DB messages

[Former Member]

Hi Karan

Can you please tell me how u scheduled the deletion jobs for XI messages using the transaction SXMB_ADM and specified the retention period as 1 day for asynchronous messages???

Thanks..

[Former Member]

Hi,

I used SXMB_ADM->configuration->Define interfaces for Archiving and Deletion periods and mentioned 1 day for all interfaces.

Then executed Schedule delete jobs. It ran successfully and deleted few messages but as i mentioned there are thousands of messages which are yet to be deleted.

Thanks