| Author |
Message
|
| Vitor |
 Posted: Fri Mar 01, 2013 9:19 am Post subject: |
 |
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| jaipalreddy wrote: |
| when application issue the MQGET call it consumes message but as an MQ administrator we can't delete the one particular msgs don't we have that authority if we have how can we delete |
As administrators you implicitly have all the authority you need as the mqm administrative id can do anything including get messages from queues.
(If you don't have access to the mqm id, please explain how you are an "MQ administrator" and how exactly you perform this role)
What you lack is a tool that can do this. You must either use one of the suggestions here, write your own or have the developers develop one for you.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
 |
| jaipalreddy |
| Posted: Fri Mar 01, 2013 9:21 am Post subject: |
|
|
Novice
Joined: 27 Feb 2013
Posts: 11
|
| so what is the meaning of this command CLEAR QL(QNMAE) PURGE does this command allows to delete the messages ? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Mar 01, 2013 9:24 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| jaipalreddy wrote: |
| so what is the meaning of this command CLEAR QL(QNMAE) PURGE does this command allows to delete the messages ? |
It means exactly and specifically what the documentation says it means. |
|
| Back to top |
|
|
| exerk |
| Posted: Fri Mar 01, 2013 9:25 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
| jaipalreddy wrote: |
| so what is the meaning of this command CLEAR QL(QNMAE) PURGE does this command allows to delete the messages ? |
The meaning is pretty obvious and crystal clear - but you don't want to use it (and can't anyway if something has an open handle on the queue).
_________________
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 |
|
|
| Vitor |
| Posted: Fri Mar 01, 2013 9:25 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| jaipalreddy wrote: |
| so what is the meaning of this command CLEAR QL(QNMAE) PURGE does this command allows to delete the messages ? |
It's the one I described here:
| Vitor wrote: |
| at a command level all you can do is clear the entire queue |
You'll also find it described here 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| jaipalreddy |
| Posted: Fri Mar 01, 2013 9:33 am Post subject: |
|
|
Novice
Joined: 27 Feb 2013
Posts: 11
|
| Vitor wrote: |
| jaipalreddy wrote: |
| so what is the meaning of this command CLEAR QL(QNMAE) PURGE does this command allows to delete the messages ? |
It's the one I described here:
| Vitor wrote: |
| at a command level all you can do is clear the entire queue |
You'll also find it described here |
okay i got the point but i have one doubt application put some messages on queue but after some time they said first message is poison message so please delete so that time what i have to do |
|
| Back to top |
|
|
| exerk |
| Posted: Fri Mar 01, 2013 9:36 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
| jaipalreddy wrote: |
| ...okay i got the point but i have one doubt application put some messages on queue but after some time they said first message is poison message so please delete so that time what i have to do |
What I suggest you do is use the facility provided within the MO71 SupportPac to copy the message to a file, hand that file to the applications people, and request they sort out their lives as to why they haven't coded to deal with poison messages - they can use the message you've given them as a working example - then delete the message for them.
_________________
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 |
|
|
| Vitor |
| Posted: Fri Mar 01, 2013 9:57 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| jaipalreddy wrote: |
| i have one doubt application put some messages on queue but after some time they said first message is poison message so please delete so that time what i have to do |
You have to delete the first message in the same way you were proposing to delete the 250th message.
You should also be ashamed as an administrator for not providing a mechanism to deal with poison messages (you might want to research backout queues) and ensuring that the developers use the mechanism provided.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| rammer |
| Posted: Fri Mar 01, 2013 10:05 am Post subject: |
|
|
Partisan
Joined: 02 May 2002
Posts: 359
Location: England
|
| Vitor wrote: |
| jaipalreddy wrote: |
| i have one doubt application put some messages on queue but after some time they said first message is poison message so please delete so that time what i have to do |
You have to delete the first message in the same way you were proposing to delete the 250th message.
You should also be ashamed as an administrator for not providing a mechanism to deal with poison messages (you might want to research backout queues) and ensuring that the developers use the mechanism provided. |
I think thats a very poor comment, not every one starts with such experience to know everything.. This forum is supposed to help / advice and point in the correct direction not to be negative like the above. |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Mar 01, 2013 10:13 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| rammer wrote: |
| I think thats a very poor comment, not every one starts with such experience to know everything.. This forum is supposed to help / advice and point in the correct direction not to be negative like the above. |
Anyone who started out asking how to delete the 250th message, and has been given a raft of suggestions, should not then need to ask how to delete the first message.
Anyone who's administering WMQ should know the basics of administering a WMQ estate. There are advanced topics you won't know, but obvious things you should; I've lost count of the number of people over the years who've been taken to task for running applications under the mqm id which is as bad as not having handling for poison messages.
I also did provide the necessary research term.
If you think it's a poor comment, I respect your opinion. I look forward to you applying similar criticism of the poster in future when a basic question from a newbie is answered with a link to the IBM training course.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| jaipalreddy |
| Posted: Fri Mar 01, 2013 10:20 am Post subject: |
|
|
Novice
Joined: 27 Feb 2013
Posts: 11
|
| Vitor wrote: |
| jaipalreddy wrote: |
| i have one doubt application put some messages on queue but after some time they said first message is poison message so please delete so that time what i have to do |
You have to delete the first message in the same way you were proposing to delete the 250th message.
You should also be ashamed as an administrator for not providing a mechanism to deal with poison messages (you might want to research backout queues) and ensuring that the developers use the mechanism provided. |
Iam new to MQ so there is nothing wrong to learn concepts which i dont know y should i feel shame? now u r an expert but once up on a time u r also a learner right? no one knows everything and there is nothing wrong to learn the concepts which we don't know  |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Fri Mar 01, 2013 10:27 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9472
Location: US: west coast, almost. Otherwise, enroute.
|
| jaipalreddy wrote: |
| ... first message is poison message so please delete so that time what i have to do |
A poison message is a message that the application cannot process for some (business) reason.
The consuming application needs to be modified to handle (process) poison messages as is appropriate for the business. The app may, for example, move the poison message to another queue designated for poison messages, for processing by another app that deals with poison messages.
Although you (and I) may have the technical power to delete messages from queues, the best-practice is for applications to delete all messages by consuming them according to business rules.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| jaipalreddy |
| Posted: Fri Mar 01, 2013 10:34 am Post subject: |
|
|
Novice
Joined: 27 Feb 2013
Posts: 11
|
| bruce2359 wrote: |
| jaipalreddy wrote: |
| ... first message is poison message so please delete so that time what i have to do |
A poison message is a message that the application cannot process for some (business) reason.
The consuming application needs to be modified to handle (process) poison messages as is appropriate for the business. The app may, for example, move the poison message to another queue designated for poison messages, for processing by another app that deals with poison messages.
Although you (and I) may have the technical power to delete messages from queues, the best-practice is for applications to delete all messages by consuming them according to business rules. |
Thanx for u r suggestion i have one doubt we have commands to move messages from one queue to another queue but in my queue there are 500 messages but only first ten were poison messages so how can we move only first ten messages to another queue is there any support pac? |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Fri Mar 01, 2013 10:41 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9472
Location: US: west coast, almost. Otherwise, enroute.
|
| jaipalreddy wrote: |
Thanx for u r suggestion i have one doubt we have commands to move messages from one queue to another queue ... |
Yes, moving ALL messages from one queue to another is supported.
| jaipalreddy wrote: |
| ...but in my queue there are 500 messages but only first ten were poison messages so how can we move only first ten messages to another queue is there any support pac? |
As explained by others, no.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Fri Mar 01, 2013 11:15 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9472
Location: US: west coast, almost. Otherwise, enroute.
|
| jaipalreddy wrote: |
| ... how can we move only first ten messages to another queue is there any support pac? |
You persist in asking the same question.
There are only two possibilities:
1) fix the application that creates the poison messages so that it stops doing so; and/or
2) fix the consuming application so that it processes poison messages out of the queue. Developers should research wmq BACKOUT COUNT and BACKOUT REQUEUE QUEUE NAME.
You should push this back to the developers, as it is their responsibility to write business-quality code.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
|
|
