| Author |
Message
|
| bhaskarreddy |
 Posted: Fri May 24, 2013 6:50 am Post subject: How to remove the Unused Messsages from the RECVQ Queue |
 |
|
Apprentice
Joined: 24 May 2013
Posts: 27
|
Hi,
My RECVQ Size is 10000, If messages size reaches 8000, I have to remove ununsed messages, Is there any possible way to get the script to remove those unused messages from RECVQ,
Thank you |
|
| Back to top |
|
 |
| PeterPotkay |
| Posted: Fri May 24, 2013 6:57 am Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
How do you define and identify an "unused" message?
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| bhaskarreddy |
| Posted: Fri May 24, 2013 7:06 am Post subject: How to remove the Unused Messsages from the RECVQ Queue |
|
|
Apprentice
Joined: 24 May 2013
Posts: 27
|
| Sometime we had connectivity issues with mainframes, that time all Messages in RECVQ, It is reaching 10000 Messages in everday morning, I am thinking if we reaches 8000 messages to remove old Messages using the script. |
|
| Back to top |
|
|
| bhaskarreddy |
| Posted: Fri May 24, 2013 7:08 am Post subject: Re: How to remove the Unused Messsages from the RECVQ Queue |
|
|
Apprentice
Joined: 24 May 2013
Posts: 27
|
| if the user exists from machine, no need to send back those message to user, Based on timestamp can we remove those messages ? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri May 24, 2013 7:09 am Post subject: Re: How to remove the Unused Messsages from the RECVQ Queue |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| bhaskarreddy wrote: |
| Sometime we had connectivity issues with mainframes, that time all Messages in RECVQ, It is reaching 10000 Messages in everday morning, I am thinking if we reaches 8000 messages to remove old Messages using the script. |
What is an "old" message? Is it messages that the application says contain data that is, for example, "green"? Is it messages that the application says are not persistent?
The easiest way to cause lots of serious production issues is for an mq administrator to start discarding messages with no understanding of what those messages mean. |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri May 24, 2013 7:10 am Post subject: Re: How to remove the Unused Messsages from the RECVQ Queue |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| bhaskarreddy wrote: |
| if the user exists from machine, no need to send back those message to user, Based on timestamp can we remove those messages ? |
If you don't want those messages if they sit on the queue for more than a given period of time "t" then why not have the sending application set them to expire after "t+30" seconds? This is the normal pattern for a reply message and these sound like they're replies to a user.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| bhaskarreddy |
| Posted: Fri May 24, 2013 7:20 am Post subject: Re: How to remove the Unused Messsages from the RECVQ Queue |
|
|
Apprentice
Joined: 24 May 2013
Posts: 27
|
| Sometimes we are unexpectly mainframes went down without notice, the users is trying to pull the data, that time the messages stored in the RECVQ, Because of mainframe down, early morning I have cleaned up those messages and restart the MQ. Is there anyway to avoid this type of problems. |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri May 24, 2013 7:30 am Post subject: Re: How to remove the Unused Messsages from the RECVQ Queue |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| bhaskarreddy wrote: |
| Is there anyway to avoid this type of problems. |
Yes. Have the sending application set message expiry on any message which has a limited shelf life.
I think I mentioned this already.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Fri May 24, 2013 7:31 am Post subject: Re: How to remove the Unused Messsages from the RECVQ Queue |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
| bhaskarreddy wrote: |
| Because of mainframe down, early morning I have cleaned up those messages and restart the MQ. Is there anyway to avoid this type of problems. |
Why did you restart the queue manager? What technical reason? For example, did a queue reach maximum depth? If so, increase maxdepth.
Were the messages you cleaned up (deleted?) worth $1, $10, $1,000,000?
_________________
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 |
|
|
| bhaskarreddy |
| Posted: Fri May 24, 2013 9:21 am Post subject: Re: How to remove the Unused Messsages from the RECVQ Queue |
|
|
Apprentice
Joined: 24 May 2013
Posts: 27
|
| our architecture frontend server one queuemanager ( sendq and recq )backend server one queuemanger (sendq and recq), frontend applicaiton put the message sendq and after recive the message backend it will process the application ( to connect mainframes, or db2 or other servers more than 10 connections ), backend some time it is down we are not getting proper notifications, that time the messages will be in RECVQ, After connections is up, we are restarting applicaitons and queuemanagers ( some times queue depth may full), this scenarios i am thinking if thrashold reaches 80%, thinking to remove those messages. Our application doesn't know mainframes is down or not. if you setup the message expiry, does it store the message in RECVQ?, If we increase queue size but there is no use this type of scenario. |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Fri May 24, 2013 9:43 am Post subject: Re: How to remove the Unused Messsages from the RECVQ Queue |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
| bhaskarreddy wrote: |
| If we increase queue size but there is no use this type of scenario. |
Are you saying that you shut down the qmgr, and then restarted it because a queue filled up? Why? What did cycling the qmgr accomplish? Please be specific.
Alter the queue to increase maxdepth. Your applications must contemplate common outages like these.
_________________
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 |
|
|
| bhaskarreddy |
| Posted: Fri May 24, 2013 9:46 am Post subject: Re: How to remove the Unused Messsages from the RECVQ Queue |
|
|
Apprentice
Joined: 24 May 2013
Posts: 27
|
| We can Increase the maxium queue depth, After that We are getting "Apparent Deadlock " message, that time we are restarting Frontend and backend applications and queuemanagers. |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Fri May 24, 2013 10:00 am Post subject: Re: How to remove the Unused Messsages from the RECVQ Queue |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
Again, I asked you specific questions, and you did not answer them.
| bruce2359 wrote: |
| Are you saying that you shut down the qmgr, and then restarted it because a queue filled up? Why? What did cycling the qmgr accomplish? Please be specific. |
When you restarted the qmgr, were the messages magically gone from the queue?
What is an "Apparent Deadlock" message? What application is issuing it?
_________________
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 |
|
|
| Vitor |
| Posted: Fri May 24, 2013 10:08 am Post subject: Re: How to remove the Unused Messsages from the RECVQ Queue |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| bhaskarreddy wrote: |
| if you setup the message expiry, does it store the message in RECVQ?, |
Why not look up message expiry in the product documentation and see?
| bhaskarreddy wrote: |
| If we increase queue size but there is no use this type of scenario. |
The only thing increased max depth gives you here is more time before it fills up.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Fri May 24, 2013 10:25 am Post subject: Re: How to remove the Unused Messsages from the RECVQ Queue |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
| Vitor wrote: |
| The only thing increased max depth gives you here is more time before it fills up. |
Or, it gives the other end of the channel an opportunity come back to life in the short-term.
Good application design needs to contemplate outages like this.
_________________
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 |
|
|
|
|
