| Author |
Message
|
| ivanachukapawn |
 Posted: Wed Sep 29, 2010 9:37 am Post subject: MQ6 - DLQ handling - 8000 messages |
 |
|
Knight
Joined: 27 Oct 2003
Posts: 561
|
I searched for posts on DLQ, runMQdlQ, ZOS, etc. and came up with useful suggestions (MA0t, RFHUTIL, etc).
But I have 8000 messages. About 7000 of them I need to trash. 1000 need to be rerouted.
Unless I'm missing something I can't run runMQdlq on ZOS and RFHUTIL is good for manual only. Any suggestions? |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed Sep 29, 2010 9:38 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
|
| Back to top |
|
|
| ivanachukapawn |
| Posted: Wed Sep 29, 2010 9:54 am Post subject: |
|
|
Knight
Joined: 27 Oct 2003
Posts: 561
|
Thanks Jeff, I didn't know this thing (CSQUTIL) existed. But perusing the ZOS System Admin manual under CSQUTIL I do not find any options/parameters that will do the things that I need. They have an option to empty the queue (I need to empty only 7k of the 8k messages). They have an option to load a queue from a dataset. They don't appear to have any more options.
My impossible wish list is for a client version of runMQdlq to process against the ZOS DLQ on a SVRCONN connection. (Thats not going to happen). |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Sep 29, 2010 10:04 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| ivanachukapawn wrote: |
| They have an option to empty the queue (I need to empty only 7k of the 8k messages). They have an option to load a queue from a dataset. They don't appear to have any more options. |
One suggestion:
Unload all 8k to a dataset with CSQUTIL.
Use SyncSort / COMPAREX / IDCAMS / anything to weed out the 7k
Reload the remaining 1k of messages using CSQUTIL
| ivanachukapawn wrote: |
| My impossible wish list is for a client version of runMQdlq to process against the ZOS DLQ on a SVRCONN connection. (Thats not going to happen). |
Certainly not. You'll have to use CSQUDLQH (runmqdlq's z/OS brother) like the rest of us.
You'll find him described in the same manual section as CSQUTIL. IIRC he has the same facilities (and rules table) as runmqsdlq.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Sep 29, 2010 10:07 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Vitor wrote: |
| Certainly not. You'll have to use CSQUDLQH (runmqdlq's z/OS brother) like the rest of us. |
My zOS skills stop at the word "CSQUTIL". |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Sep 29, 2010 10:11 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
| Vitor wrote: |
| Certainly not. You'll have to use CSQUDLQH (runmqdlq's z/OS brother) like the rest of us. |
My zOS skills stop at the word "CSQUTIL". |
This is sufficient for 90% of all z/OS tasks. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| zpat |
| Posted: Wed Sep 29, 2010 10:53 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5867
Location: UK
|
Send the messages to a distributed queue manager and use the DLQ handler on them there.
You don't say if this is a one-off or not. But it's easy enough to move them off (CSQUTIL perhaps to a remote queue) and process them off the mainframe.
MO71 has a neat unload/load function that can remove DLH and select on various criteria.
IBM provide the (sample) source for runmqdlq so it could probably be made into a client program easily enough by re-linking it with the client libraries. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Sep 29, 2010 12:19 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
No need... as indicated there is an equivalent to runmqdlq on the MainFrame.
Use it. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| ivanachukapawn |
| Posted: Thu Sep 30, 2010 3:18 am Post subject: |
|
|
Knight
Joined: 27 Oct 2003
Posts: 561
|
FJB-SAPER,
I am using your advice (to use the ZOS MQ utilities) and I am most grateful to you for this information. One of these days I'll get some experience on ZOS MQ and can avoid these desperate posts on mqseries.net. In the meantime, thanks a lot for your help. |
|
| Back to top |
|
|
| Mr Butcher |
| Posted: Thu Sep 30, 2010 3:42 am Post subject: |
|
|
Padawan
Joined: 23 May 2005
Posts: 1716
|
as already suggested, CSQUDLQH is your friend. See the z/OS system administration manual for details how to run it. you may need other utilities first to investigate which returncodes to dump and wich to keep / reroute / retry. MA10 ISPF utilities maybe or some kind of queue browser. see your z/Os mq administrator, he can help you, also with CSQUDLQH
_________________
Regards, Butcher |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Sep 30, 2010 4:00 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| ivanachukapawn wrote: |
FJB-SAPER,
I am using your advice (to use the ZOS MQ utilities) and I am most grateful to you for this information. |
You're welcome.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| ivanachukapawn |
| Posted: Thu Sep 30, 2010 4:04 am Post subject: |
|
|
Knight
Joined: 27 Oct 2003
Posts: 561
|
| Sorry Vitor, I see that you were the one with the great suggestion about CSQUDLQH. I should have thanked all you guys (Grand Poobahs, grandmasters, MQJEFF, FJB, you, et al). |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Sep 30, 2010 4:22 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| ivanachukapawn wrote: |
| Sorry Vitor, I see that you were the one with the great suggestion about CSQUDLQH. |
I toil in obscurity. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Sep 30, 2010 4:58 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Vitor wrote: |
| ivanachukapawn wrote: |
| Sorry Vitor, I see that you were the one with the great suggestion about CSQUDLQH. |
I toil in obscurity. |
I'm happy to publish the photos... |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Sep 30, 2010 4:59 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
| Vitor wrote: |
| ivanachukapawn wrote: |
| Sorry Vitor, I see that you were the one with the great suggestion about CSQUDLQH. |
I toil in obscurity. |
I'm happy to publish the photos... |
 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
