ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » General IBM MQ Support » Delete MQSI input queue (MQ + broker v.5x)?

Post new topic  Reply to topic
 Delete MQSI input queue (MQ + broker v.5x)? « View previous topic :: View next topic » 
Author Message
gechu
PostPosted: Wed Aug 20, 2008 3:48 am    Post subject: Delete MQSI input queue (MQ + broker v.5x)? Reply with quote

Apprentice

Joined: 27 Feb 2008
Posts: 48

Hi all,

This might seem like an easily solved problem, but yet I fail.

The queue I want to delete is held open by a broker flow (it´s the input queue to that flow). And I simply want to delete it.

I´ve tried:
- Stopped the flow
- Removed the flow

I find it strange, when I´ve removed the flow and waited for maybe 10 minutes, I am able to run a delete queue commandwithout getting a "queue is open" error. However, even though I don´t get any errors, the queue is still there when I look again...

The only way I managed to solve the problem was to force a shutdown of the entire broker service and then remove the queue using runmqsc. But that is a very not so nice solution so I was hoping for some other suggestings from you guys to solve this problem?

Thanks,

Erik
Back to top
View user's profile Send private message
AkankshA
PostPosted: Wed Aug 20, 2008 4:01 am    Post subject: Reply with quote

Grand Master

Joined: 12 Jan 2006
Posts: 1494
Location: Singapore

Does it happen always.. or happen ed only once..


after deleting the queue, does display ql show you the queue ??

What are the IPPROCS and OPPROCS before deleting the queue..
_________________
Cheers
Back to top
View user's profile Send private message Visit poster's website
gechu
PostPosted: Wed Aug 20, 2008 4:12 am    Post subject: Reply with quote

Apprentice

Joined: 27 Feb 2008
Posts: 48

Hi,

If I remember correcly was the IPPROCS set to "1". Can you please give be a brief explaination about IPPROCS and OPPROCS? Is it possible to release these handles (even in MQ v5x)?
Back to top
View user's profile Send private message
AkankshA
PostPosted: Wed Aug 20, 2008 4:21 am    Post subject: Reply with quote

Grand Master

Joined: 12 Jan 2006
Posts: 1494
Location: Singapore

They show the number of processes polling your queue for input and output respectively..


So are you not able to recreate the scenerio ?
_________________
Cheers
Back to top
View user's profile Send private message Visit poster's website
gechu
PostPosted: Wed Aug 20, 2008 4:41 am    Post subject: Reply with quote

Apprentice

Joined: 27 Feb 2008
Posts: 48

I think I can do it. I´ve checked and it has queue definitions containing "default bind on open".

Do you have any clues on how to proceed with the "real" deletetion of this queue?
Back to top
View user's profile Send private message
David.Partridge
PostPosted: Wed Aug 20, 2008 5:19 am    Post subject: Reply with quote

Master

Joined: 28 Jun 2001
Posts: 249

Make the queue get inhibited - that will stop programs from opening it for input ...
_________________
Cheers,
David C. Partridge
Back to top
View user's profile Send private message
PeterPotkay
PostPosted: Wed Aug 20, 2008 5:46 am    Post subject: Reply with quote

Poobah

Joined: 15 May 2001
Posts: 7722

In version 5.0 and earler of the Broker stopping a flow didn't stop it. It just caused the flow to break out of its MQGET loop. The queues it had open remained opened. If you wanted to change or delete them you had to go the extra step of actually removing the flow, making your q change (i.e. change remote q name) and then redeploy.

In 6.0 of the Broker, a stop of a flow is a real stop. The queues are released.


If in WB-IMB toy stopped and removed the flow, yet the q still complains that something has, you might have additional copies of your flow in aother execution groups, or maybe another app has the q open (channel or program for puts, monitoring tool has it open for MQINQ, etc)
_________________
Peter Potkay
Keep Calm and MQ On
Back to top
View user's profile Send private message
gechu
PostPosted: Thu Aug 21, 2008 2:29 am    Post subject: Reply with quote

Apprentice

Joined: 27 Feb 2008
Posts: 48

Thanks all for the input!

I can confirm the strange behaviour of broker flows that PeterPotkay described.

David.Partridge, tried setting the queue to "get inhibited", but the flow would not release it. So sadly, the only way to completly remove MQSI input queues in MQ 5.x, seems to require that the flow is removed.

Something which might not be related to this issue, but might be good to be aware of, is that one way to remove handles in MQ 6.x is to type:
Code:
dis conn(*) where(objname eq myQueue)
(thx fjb_saper for letting me know about this command). This will return the connection ID that is used to hold the MQSI input queue myQueue. Then simply type something in line with:
Code:
stop conn(connId)
I guess it depends on what reconned time the current broker flow is set to use, but last time I used this I had a couple of minutes to type:
Code:
delete ql(myQueue)
and solve my "queue open" issue.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » General IBM MQ Support » Delete MQSI input queue (MQ + broker v.5x)?
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.