Author |
Message
|
hello2jitendra |
Posted: Wed Nov 08, 2006 1:50 am Post subject: How to read and delete particular messages from MQ queue |
|
|
Apprentice
Joined: 26 Jun 2006 Posts: 25
|
Dear All
I have some messages stuck in MQ queues. But other messages are godd,
i can see the msg ID of the messages usong amqsbcg application.
Now i want to delete those selected messages from queue .
Is there any utility available where i can give the message id and delete particular messages from Queue.
Thanks in Advance
Jitendra |
|
Back to top |
|
 |
sebastianhirt |
Posted: Wed Nov 08, 2006 1:51 am Post subject: |
|
|
Yatiri
Joined: 07 Jun 2004 Posts: 620 Location: Germany
|
You might try support pack MO71 |
|
Back to top |
|
 |
dkeister |
Posted: Tue Nov 21, 2006 12:25 pm Post subject: |
|
|
Disciple
Joined: 25 Mar 2002 Posts: 184 Location: Purchase, New York
|
I am adding function to MQExerciser to do just this. I need a beta customer if you are still having the problem. Please contact me at dean@mqexerciser.com if you are still interested. _________________ Dean Keister |
|
Back to top |
|
 |
zpat |
Posted: Tue Nov 21, 2006 1:00 pm Post subject: |
|
|
 Jedi Council
Joined: 19 May 2001 Posts: 5866 Location: UK
|
RFHUTIL/C should be able to do this. Support Pac IH03 |
|
Back to top |
|
 |
RogerLacroix |
Posted: Tue Nov 21, 2006 9:50 pm Post subject: |
|
|
 Jedi Knight
Joined: 15 May 2001 Posts: 3264 Location: London, ON Canada
|
|
Back to top |
|
 |
kspranava |
Posted: Wed Nov 29, 2006 1:27 am Post subject: |
|
|
 Centurion
Joined: 27 Apr 2003 Posts: 124
|
Hi,
Quote: |
zpat wrote:
RFHUTIL/C should be able to do this. Support Pac IH03 |
Am afraid, it is not possible using rfhutil. Lets say, if I want to delete 5th message alone in a queue which has 10 messages, rfhutil cannot help us. Correct me if am wrong.
--kspranava. |
|
Back to top |
|
 |
zpat |
Posted: Wed Nov 29, 2006 2:30 am Post subject: |
|
|
 Jedi Council
Joined: 19 May 2001 Posts: 5866 Location: UK
|
OK, here's how you do it with RFHUTIL/C
Press "start browse" after entering the queue manager and queue name
Press "browse next" until you reach the message you want to delete (you can see the message data in the data tab and the MQMD in the mqmd tab.
Then press "end browse" on the main tab.
Then check the "get by msg id" check box on the main tab (the msgid used will be the one from the message last browsed).
Press "Read Q" and the target message will be destructively got.
(This assumes the messages have unique message ids, but you can also select by correlid if you want to). |
|
Back to top |
|
 |
kspranava |
Posted: Wed Nov 29, 2006 2:37 am Post subject: |
|
|
 Centurion
Joined: 27 Apr 2003 Posts: 124
|
Hi zpat,
Excellent, thanks for uncovering the myth!
-kspranava |
|
Back to top |
|
 |
dkeister |
Posted: Mon Dec 04, 2006 6:36 am Post subject: |
|
|
Disciple
Joined: 25 Mar 2002 Posts: 184 Location: Purchase, New York
|
A little late on this thread, but MQExerciser also can do this.
Open the queue and select the browse button.
You get a list of all the messages on the queue.
Select the message you want to delete.
At that point, you can see the message text and MQMD.
Now you can <Clear>, <Get>, or <Edit> the message.
Get a free version at www.mqexerciser.com _________________ Dean Keister |
|
Back to top |
|
 |
mvarghese |
Posted: Thu Dec 28, 2006 7:00 pm Post subject: |
|
|
Centurion
Joined: 27 Sep 2006 Posts: 141
|
Hi Pranav,
If a case like if u want to delete the message around 2k...ie postion from 4 th to 2004th in queue contains 4k messages.
then i seen that facilty in a tool called WMQTool..ie free for only 1 month...U can try that... _________________ Jain Varghese |
|
Back to top |
|
 |
|