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 IndexGeneral IBM MQ SupportUnable to Delete Queue due to UNCOM= Yes

Post new topicReply to topic Goto page 1, 2  Next
Unable to Delete Queue due to UNCOM= Yes View previous topic :: View next topic
Author Message
ET
PostPosted: Wed Jun 16, 2010 1:14 am Post subject: Unable to Delete Queue due to UNCOM= Yes Reply with quote

Newbie

Joined: 15 Jun 2010
Posts: 4

Hi ,

I'm unable a delete a transmission Queue which is obsolete. I tried to check the connections to Queue but nothing appers. Queue has uncom message because of it I'm unable to delete it.


________________________________________________

dis qs(MQP1) uncom
20 : dis qs(MQP1) uncom
AMQ8450: Display queue status details.
QUEUE(MQP1) TYPE(QUEUE)
CURDEPTH(0) UNCOM(YES)

dis qs(MQP1) type(handle)
30 : dis qs(MQP1) type(handle)
AMQ8565: Queue Status not found.

dis ql(MQP1) Curdepth
22 : dis ql(MQP1) Curdepth
AMQ8409: Display Queue details.
QUEUE(MQP1) TYPE(QLOCAL)
CURDEPTH(0)

delete ql(MQP1) purge
21 : delete ql(MQP1) purge
AMQ8143: WebSphere MQ queue not empty.
_____________________________________________________

Can anyone help me to resolve it. These defs need to removed.
Back to top
View user's profile Send private message
Vitor
PostPosted: Wed Jun 16, 2010 5:02 am Post subject: Re: Unable to Delete Queue due to UNCOM= Yes Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

ET wrote:
AMQ8143: WebSphere MQ queue not empty.


From the documentation:

Quote:
AMQ8143: WebSphere MQ queue not empty.
Severity:
40 : Stop Error

Explanation:
The queue <insert_5> specified in <insert_2> is not empty or contains uncommitted updates.

Response:
Commit or roll back any uncommitted updates. If the command is DELETE QLOCAL, use the CLEAR QLOCAL command to clear the messages from the queue. Then try the command again.




_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
ET
PostPosted: Wed Jun 16, 2010 5:42 am Post subject: Reply with quote

Newbie

Joined: 15 Jun 2010
Posts: 4

Hi Viktor,

Thanks for the response, but there is no indoubt transaction to the Qmanager and there is no handles to the Queue. Depth as mention before is Zero and has one uncommited message. Not sure how to remove or commit the message to remove the Queue. Is there a way to commit it since I'm unable to see indoubt transaction.
--------------------------------------------------------------------------
C:\Documents and Settings\TT>dspmqtrn -e -i -m WQM1
There are no prepared transactions.
--------------------------------------------------------------------------
Back to top
View user's profile Send private message
Vitor
PostPosted: Wed Jun 16, 2010 5:57 am Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

ET wrote:
Not sure how to remove or commit the message to remove the Queue.


And you can't use the clear command as specified in the documentation (which I kindly posted) because.......?
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
ET
PostPosted: Wed Jun 16, 2010 6:11 am Post subject: Reply with quote

Newbie

Joined: 15 Jun 2010
Posts: 4

Hi Vitor,

I tried using the Clear commnd before itself ..it didn't work.


------------------------------------------------------
clear ql(MQP1)
12 : clear ql(MQP1)
AMQ8143: WebSphere MQ queue not empty.

dis qs(MQP1) uncom
13 : dis qs(MQP1) uncom
AMQ8450: Display queue status details.
QUEUE(MQP1) TYPE(QUEUE)
CURDEPTH(0) UNCOM(YES)
-------------------------------------------------------
Back to top
View user's profile Send private message
Vitor
PostPosted: Wed Jun 16, 2010 6:55 am Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

The obvious remedies are to bounce the queue manager (good for non-persistent messages) and the IH03 support pac
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
gbaddeley
PostPosted: Wed Jun 16, 2010 3:10 pm Post subject: Reply with quote

Jedi

Joined: 25 Mar 2003
Posts: 2431
Location: Melbourne, Australia

Try putting a message to the queue and then getting it (eg. using amqsput & amqsget). Try bouncing the queue manager. It looks like the queue is in an inconsistent state. MQ may repair the state of the queue in the right circumstances.
_________________
Glenn
Back to top
View user's profile Send private message
ET
PostPosted: Thu Jun 17, 2010 2:56 am Post subject: Reply with quote

Newbie

Joined: 15 Jun 2010
Posts: 4

Thanks Vitor and gbaddeley

Using sample API's I was able to put and get test message but not able to delete it. During the weekend maintenance I will recycle the qmgr and delete the queue. some thing weird with the queue!
Back to top
View user's profile Send private message
mqjeff
PostPosted: Thu Jun 17, 2010 4:31 am Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

http://publib.boulder.ibm.com/infocenter/wmqv7/v7r0/index.jsp?topic=/com.ibm.mq.amqzag.doc/fa15890_.htm

I'm not quite sure who gets this, but someone else in this thread should have at least mentioned the above...
Back to top
View user's profile Send private message
Vitor
PostPosted: Thu Jun 17, 2010 6:11 am Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

mqjeff wrote:
http://publib.boulder.ibm.com/infocenter/wmqv7/v7r0/index.jsp?topic=/com.ibm.mq.amqzag.doc/fa15890_.htm

I'm not quite sure who gets this, but someone else in this thread should have at least mentioned the above...


I had discounted that as the OP wasn't getting anything out of dspmqtrn
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
bruce2359
PostPosted: Thu Jun 17, 2010 7:19 am Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 9306
Location: US: west coast, almost. Otherwise, enroute.

There is another method:
1) navigate down the filepath to the .../queues/MPQ1
2) inside the MPQ1 directory is a file named q
3) with a DOS/UNIX command, delete the q file
This will damage the MPQ1 queue object.
Now, you should be able to delete it with the delete ql(MPQ1) command
_________________
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
View user's profile Send private message
aditya.aggarwal
PostPosted: Thu Jun 17, 2010 7:59 am Post subject: Reply with quote

Master

Joined: 13 Jan 2009
Posts: 252

Was there any FDC in your system with error description "disk full" with errno 0 for this queue?
Back to top
View user's profile Send private message
JosephGramig
PostPosted: Fri Jun 18, 2010 10:06 am Post subject: Reply with quote

Grand Master

Joined: 09 Feb 2006
Posts: 1228
Location: South Florida, USA

bruce2359,

Do you subscribe to the notion, "Violence is the way!"?

Reminds me of the two kids in "Talladega Nights" running around screaming "Anarchy! Anarchy!".
Back to top
View user's profile Send private message AIM Address
Vitor
PostPosted: Fri Jun 18, 2010 11:04 am Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

bruce2359 wrote:
There is another method:
1) navigate down the filepath to the .../queues/MPQ1
2) inside the MPQ1 directory is a file named q
3) with a DOS/UNIX command, delete the q file
This will damage the MPQ1 queue object.
Now, you should be able to delete it with the delete ql(MPQ1) command


Subtle....
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
bruce2359
PostPosted: Fri Jun 18, 2010 11:15 am Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 9306
Location: US: west coast, almost. Otherwise, enroute.

Quote:
Do you subscribe to the notion, "Violence is the way!"?

No. It's more like "occasional violence is a way." This is referred to as "needful violence."
Sometimes a hammer is what you need.
_________________
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
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Goto page 1, 2  Next Page 1 of 2

MQSeries.net Forum IndexGeneral IBM MQ SupportUnable to Delete Queue due to UNCOM= Yes
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.