| Author |
Message
|
| karthik_ps |
 Posted: Mon Oct 21, 2013 4:24 am Post subject: Deleting messages that has specific string in the piled up Q |
 |
|
Apprentice
Joined: 10 Dec 2008
Posts: 43
|
Hi All,
I am in situation to clear messages that are having string "ABC" in the payload. Currently curdepth of the queue is around 70000. One of the hardest way is to browse the message using ( Support pack - MA96-mqbrowser) and find out its message id. Then based on the message id, we can issue the command to remove it from the queue. Is there simpler way to do it ?
Thanks in advance.
Karthik |
|
| Back to top |
|
 |
| exerk |
| Posted: Mon Oct 21, 2013 4:49 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
Dump the lot to file using MO03 and parse the file to identify the messages you want removed, remove them then reload the remaining messages?
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| zpat |
| Posted: Mon Oct 21, 2013 4:56 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
You could use MO71 browse message interface to search for that string then delete all the messages that were displayed.
Suggest practicising this on another queue to understand it.
_________________
Well, I don't think there is any question about it. It can only be attributable to human error. This sort of thing has cropped up before, and it has always been due to human error. |
|
| Back to top |
|
|
| RogerLacroix |
| Posted: Mon Oct 21, 2013 9:28 am Post subject: |
|
|
Jedi Knight
Joined: 15 May 2001
Posts: 3264
Location: London, ON Canada
|
|
| Back to top |
|
|
| wmbwmq |
| Posted: Mon Oct 21, 2013 9:36 am Post subject: |
|
|
Acolyte
Joined: 18 Jul 2011
Posts: 66
|
qload with "-s" option is the easiest approach.
of course, you might want to do some test runs on some other queues and make sure right messages are being removed... |
|
| Back to top |
|
|
| karthik_ps |
| Posted: Wed Oct 23, 2013 5:10 am Post subject: Resovled : Deleting messages that has specific string in the |
|
|
Apprentice
Joined: 10 Dec 2008
Posts: 43
|
| Thanks all for the suggestion. I had used qload to do the activity. |
|
| Back to top |
|
|
|
|
