| Author |
Message
|
| EricL |
 Posted: Mon Nov 10, 2014 6:36 pm Post subject: Tools/Utility used to remove/transfer single message |
 |
|
Centurion
Joined: 10 Oct 2014
Posts: 102
|
Hi Guys,
When doing support work, I sometimes need to do:
1. remove a single message from a queue, say poisonous message
2. transfer a message from a DLQ back to normal queue
Just would like to know what tools/utility is commonly used for above purpose?
Thanks in advance !
Eric |
|
| Back to top |
|
 |
| MQsysprog |
| Posted: Mon Nov 10, 2014 11:30 pm Post subject: |
|
|
Centurion
Joined: 24 Feb 2014
Posts: 116
|
|
| Back to top |
|
|
| zpat |
| Posted: Tue Nov 11, 2014 12:36 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
MO71 is very good for this purpose and easier to use as a GUI (in fact both were written by Paul Clarke).
MO71 was an IBM support pac and is now a vendor product, but you can still try the older version for free.
http://www.mqgem.com/mo71_751.html
_________________
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: Tue Nov 11, 2014 3:55 pm Post subject: Re: Tools/Utility used to remove/transfer single message |
|
|
Jedi Knight
Joined: 15 May 2001
Posts: 3264
Location: London, ON Canada
|
| EricL wrote: |
1. remove a single message from a queue, say poisonous message
2. transfer a message from a DLQ back to normal queue |
Please have a look at MQ Visual Edit. It can do that plus a whole lot more.
Regards,
Roger Lacroix
Capitalware Inc.
_________________
Capitalware: Transforming tomorrow into today.
Connected to MQ!
Twitter |
|
| Back to top |
|
|
| exerk |
| Posted: Wed Nov 12, 2014 12:57 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
Not forgetting that there is a supplied dead-letter handler supplied with the product.
EricL, I suggest you push the application owners to include poison-message handling logic within their application, which is where it properly belongs.
_________________
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 |
|
|
| Michael Dag |
| Posted: Wed Nov 12, 2014 4:12 am Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
add supportpac MS0P to your MQExplorer if you are using that to connect to your queue manager
_________________
Michael
MQSystems Facebook page |
|
| Back to top |
|
|
| EricL |
| Posted: Wed Nov 12, 2014 12:37 pm Post subject: |
|
|
Centurion
Joined: 10 Oct 2014
Posts: 102
|
Hi guys,
Thanks so much for ALL your response.
I installed MO71 on my laptop and verifying it, so far so good as I can delete/copy/move messages around.
Just one question, I have a very big q, with over 20,000 messages in it, but looks like MQ71 has limit to open only first 10,000 messages, though there is "Display Range", but when specify a big number, say 11000 in it, it only show 10,000 messages.
Question is, how to jump to message after 10000?
Thanks !
Eric |
|
| Back to top |
|
|
| JosephGramig |
| Posted: Wed Nov 12, 2014 1:10 pm Post subject: |
|
|
Grand Master
Joined: 09 Feb 2006
Posts: 1244
Location: Gold Coast of Florida, USA
|
qload (MO03) is another tool you should get familiar with because you might only have the command line at some point. Search this site and you will find discussions about how to unload/copy a queue and chop the file up for chunked loading/reloading.
Last edited by JosephGramig on Thu Nov 13, 2014 6:05 am; edited 1 time in total |
|
| Back to top |
|
|
| PaulClarke |
| Posted: Wed Nov 12, 2014 1:17 pm Post subject: |
|
|
Grand Master
Joined: 17 Nov 2005
Posts: 1002
Location: New Zealand
|
Eric,
Have you tried displaying a range like 20000,30000 ?
It rings a bell that earlier versions of MO71 had a limitation on how many messages it would display but I thought you could specify whatever range you like. In the Preferences Dialog - in the Browse Tab - you can specify the maximum number of messages you wish to be able to browse.
If you are using the free version of MO71 there may well be some restrictions, it's a long time since I've used a version that old.
If you would like to try out the latest version then just send an email to support@mqgem.com and I'd be happy to send you a trial licence. There are quite a number of new features in the queue browsing area.
Regards,
Paul.
_________________
Paul Clarke
MQGem Software
www.mqgem.com |
|
| Back to top |
|
|
| EricL |
| Posted: Sat Nov 15, 2014 4:51 am Post subject: |
|
|
Centurion
Joined: 10 Oct 2014
Posts: 102
|
Thanks Grand and Paul.
I've tried a range of 20000 and above in Preferences Dialog, but again messages only show up to 10000, so think there is limition there.
Anyway, I've requested a latest trial version of MO71 through email to support@mqgem.com, let's see how's the latest version work
Thanks guys.
Eric |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sat Nov 15, 2014 4:03 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Just as a thought check with Paul that the 10,000 limit you see is not tied to the default max uncommitted transactions... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| PaulClarke |
| Posted: Sat Nov 15, 2014 11:05 pm Post subject: |
|
|
Grand Master
Joined: 17 Nov 2005
Posts: 1002
Location: New Zealand
|
No, this is browsing.....nothing to do with transactions. However, if you wanted to move all the messages to another queue then you would be limited by the max uncomitted messages. MO71 will do it in bunches of messages.
Cheers,
Paul.
_________________
Paul Clarke
MQGem Software
www.mqgem.com |
|
| Back to top |
|
|
|
|
