ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » General IBM MQ Support » Deleting messages that has specific string in the piled up Q

Post new topic  Reply to topic
 Deleting messages that has specific string in the piled up Q « View previous topic :: View next topic » 
Author Message
karthik_ps
PostPosted: Mon Oct 21, 2013 4:24 am    Post subject: Deleting messages that has specific string in the piled up Q Reply with quote

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
View user's profile Send private message
exerk
PostPosted: Mon Oct 21, 2013 4:49 am    Post subject: Reply with quote

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
View user's profile Send private message
zpat
PostPosted: Mon Oct 21, 2013 4:56 am    Post subject: Reply with quote

Jedi Council

Joined: 19 May 2001
Posts: 5849
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
View user's profile Send private message
RogerLacroix
PostPosted: Mon Oct 21, 2013 9:28 am    Post subject: Reply with quote

Jedi Knight

Joined: 15 May 2001
Posts: 3252
Location: London, ON Canada

Hi,

Both MQ Visual Edit and MQ Batch Toolkit have a feature called "Clear Queue by Matching String" which will do exactly what you want.

Regards,
Roger Lacroix
Capitalware Inc.
_________________
Capitalware: Transforming tomorrow into today.
Connected to MQ!
Twitter
Back to top
View user's profile Send private message Visit poster's website
wmbwmq
PostPosted: Mon Oct 21, 2013 9:36 am    Post subject: Reply with quote

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
View user's profile Send private message
karthik_ps
PostPosted: Wed Oct 23, 2013 5:10 am    Post subject: Resovled : Deleting messages that has specific string in the Reply with quote

Apprentice

Joined: 10 Dec 2008
Posts: 43

Thanks all for the suggestion. I had used qload to do the activity.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » General IBM MQ Support » Deleting messages that has specific string in the piled up Q
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.