| Author |
Message
|
| Rahul999 |
 Posted: Wed May 30, 2007 5:02 am Post subject: How to delete all the Local Queues in a Queue Manager |
 |
|
Centurion
Joined: 14 Mar 2007
Posts: 134
|
Hi All,
I have more than 100 local queues in my Queue Manager.
Is there any way i can delete all the Local Queues at one go.
Currenly, my enviroment is windows. |
|
| Back to top |
|
 |
| marcin.kasinski |
| Posted: Wed May 30, 2007 5:05 am Post subject: Re: How to delete all the Local Queues in a Queue Manager |
|
|
Sentinel
Joined: 21 Dec 2004
Posts: 850
Location: Poland / Warsaw
|
You ca do it by writing one mqsc script.
_________________
Marcin |
|
| Back to top |
|
|
| Rahul999 |
| Posted: Wed May 30, 2007 5:26 am Post subject: |
|
|
Centurion
Joined: 14 Mar 2007
Posts: 134
|
Hi Marcin,
But again it will involve writing the queue names of all the local queues in the mqsc script.
Is not there any Generic way to delete all the Local Queues. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed May 30, 2007 5:34 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
So get the script to obtain all the queue names, then use these names to fuel the delete.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| marcin.kasinski |
| Posted: Wed May 30, 2007 5:37 am Post subject: |
|
|
Sentinel
Joined: 21 Dec 2004
Posts: 850
Location: Poland / Warsaw
|
| Rahul999 wrote: |
Hi Marcin,
But again it will involve writing the queue names of all the local queues in the mqsc script.
Is not there any Generic way to delete all the Local Queues. |
You can use saveqmgr to dump QMGR then you can use output to generate "delete" script .
_________________
Marcin |
|
| Back to top |
|
|
| tleichen |
| Posted: Wed May 30, 2007 6:49 am Post subject: |
|
|
Yatiri
Joined: 11 Apr 2005
Posts: 663
Location: Center of the USA
|
There are system queues and queues that are supplied with the queue manager that are local queues. I doubt that you really want to delete ALL local queues. 
_________________
IBM Certified MQSeries Specialist
IBM Certified MQSeries Developer |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Wed May 30, 2007 12:18 pm Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7723
|
The MO71 Support Pack:
Queue List...Refresh...Control Select all the queues you don't care about...click delete once. Buh-bye queues. I once had 3000 temp dyn queues I needed to delete. Took 5 seconds in MO71.
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| wschutz |
| Posted: Mon Jun 04, 2007 10:02 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
| marcin.kasinski wrote: |
| Rahul999 wrote: |
Hi Marcin,
But again it will involve writing the queue names of all the local queues in the mqsc script.
Is not there any Generic way to delete all the Local Queues. |
You can use saveqmgr to dump QMGR then you can use output to generate "delete" script . |
From the saveqmgr readme:
| Code: |
Here's a little script to delete all the queues that begin with AMQ (even the PERMDYN ones):
export QM=WBRK_QM
./saveqmgr.linux -m$QM -1 -p -c | grep \(\'AMQ | gawk '{print "delete ql",$3}' | runmqsc $QM
|
_________________
-wayne |
|
| Back to top |
|
|
|
|
