Delete entries from SMQ2

[Former Member]

Hello all,

We have about 500,000 entries in SMQ2 we want to delete.

How can i delete those entries from SMQ2.

I have senn note  760113 - Delete unprocessed LUWs in the qRFC :
Using : RSTRFCIDS report and report RSQIWKEX,

Which one should I used and how the step?

Thanks for any help-

Reza

[Reagan · Accepted solution]

Hello Reza

The SAP note 760113 - Delete unprocessed LUWs in the qRFC speaks about two reports RSTRFCQD and RSTRFCQDS and here is what the note says.

The outbound LUWs that are no longer required can either be deleted for a complete queue using report RSTRFCQD (Standard, Note 763255) or according to selection criteria using report RSTRFCQDS (Support Package)

The report RSQIWKEX is used to reset the queue entries status.

864333 - RSQOWKEX & RSQIWKEX start Running(Executed) queues

Regards

RB

[Former Member · Accepted solution]

Hello Reagan,

I will try that and come back back with result.

Thanks

Reza

[Former Member · Accepted solution]

Hello Reagan,

I am this problem in Inbound Queue SMQ1 in the note :

760113 - Delete unprocessed LUWs in the qRFC it is possible to use RSTRFCIDS report for deletete this indound Queue entry.

Any exsample how can I start this report?

Thanks

[Reagan · Accepted solution]

Hello Reza

Yes you can use report RSTRFCIDS for the deleteion of inbound queues.

Call Tx SE38 - RSTRFCIDS

You need to provide the queue name and the time period.

Regards

RB

[Former Member · Accepted solution]

Hello Reagan,

Thanks Again for help,

I did used  report RSTRFCIDS, it take long time and that still runing. Is it any bach job for this action.

Thanks

Reza

[Reagan · Accepted solution]

Hello Reza,

Just schedule the report in the background.

Select the menu "Program" - "Execute in Background"

The report will be executed in the background and the job can be checked using Tx SM37

Regards

RB

[Former Member · Accepted solution]

Hello Reagan,

I have about 419.049 Number of Queues, I will try that-

Thanks again

[Former Member · Accepted solution]

Hello Reagan,

Thanks for help, It is good to create a bach job.  Is it faster way to deletet alle entry from SMQ2?

Each bach job report RSTRFCIDS, takes 40 min.

And I have about 419.049 Number of Queues.

Thanks for any advice.

Reza

[Reagan · Accepted solution]

Hello Reza

I do not know of any other report that will let you delete multiple queues in a single execution.

Sorry about that.

Good Luck

RB

[Former Member · Accepted solution]

Hello Reagan.

Thanks for help. I will continue by using the same report.

Reza

[former_member182657]

This message was moderated.