is it possible to quickly delete all processed messages from XI

[Former Member]

Hi all,

In our project systems I would like to remove all messages from the system after testing phase.

We run XI 3.0 sp18 (soon sp20).

I do know about archiving but it seems we cannot start

the archiving because of some large message being stuck.

I know we should adress that problem, but in our project system it is a waste of time. The osscall taking ages now,

and the real problem is not to fix the big message but to

be able to start archiving as such and the switchprocedure

One alternative is to re-install from scratch, but I was hoping

there might be a quicker approach.

[prateek]

Yes u can schedule the reports RSXMB_MARK_DELETABLE_MESSAGES and

RSXMB_DELETE_MESSAGES for small durations.

But make sure that u dont need these messages as it is not a recommended method.

Regards,

Prateek

[Former Member]

Thansk for the reply. your approach is

is the normal way of deleting messages but it fails.

question is whether there are procedures or scripts that

remove all the messages "behind the back" of XI,

without regard for their status, mutual relations or other

stuff. We just want an empty database for our test and QA

system.

basically we want to get back to the moment after installation (and configuration).