| Author |
Message
|
| sapna |
 Posted: Tue Oct 14, 2008 2:08 am Post subject: Uncommitted Messages on Dead Letter Queue |
 |
|
Novice
Joined: 14 Oct 2008
Posts: 10
|
Hi,
Can there be Uncommitted messages on dead letter queue. Coz I can see the queue depth of dead letter queue as 2 but when I browse nothing is there.
Thanks in Advance,
Sapna  |
|
| Back to top |
|
 |
| atheek |
| Posted: Tue Oct 14, 2008 3:29 am Post subject: |
|
|
Partisan
Joined: 01 Jun 2006
Posts: 327
Location: Sydney
|
| what does dis qs(<Name of Dead Letter Queue>) UNCOM show? |
|
| Back to top |
|
|
| Mr Butcher |
| Posted: Tue Oct 14, 2008 3:32 am Post subject: |
|
|
Padawan
Joined: 23 May 2005
Posts: 1716
|
yes, it is possible. what does the qstatus shows about uncomitted messages? are the two messages still there after your browse? if not, then they exired on the DLQ
_________________
Regards, Butcher |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Oct 14, 2008 4:34 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
As Mr Butcher so nicely said i would suspect message expiry being in play before I would suspect uncommitted messages. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| sapna |
| Posted: Thu Oct 16, 2008 2:03 am Post subject: |
|
|
Novice
Joined: 14 Oct 2008
Posts: 10
|
Hi,
UNCOM shows Yes. And these are the messages that have been into the dead letter queue on the receiving end because the destination queue was full.
And after this even the destination local queue shows uncommitted messages. Even after I tried resolving the channel on the sending end the local queue on the receiving end shows uncommitted messges.
Thanks and Regards,
Sapna  |
|
| Back to top |
|
|
| David.Partridge |
| Posted: Fri Oct 17, 2008 12:00 am Post subject: |
|
|
Master
Joined: 28 Jun 2001
Posts: 249
|
Hmmm Are you sure there isn't an application that's putting messages that hasn't yet committed them?
_________________
Cheers,
David C. Partridge |
|
| Back to top |
|
|
| David.Partridge |
| Posted: Fri Oct 17, 2008 12:10 am Post subject: |
|
|
Master
Joined: 28 Jun 2001
Posts: 249
|
Ooops talking about messages put by a channel - yes, both target queue and DLQ can have uncommitted messages. A channel won't commit persistent messages onto target queue (or DLQ) until BATCHSZ number of messages completes or BATCHINT expires.
_________________
Cheers,
David C. Partridge |
|
| Back to top |
|
|
| sapna |
| Posted: Fri Oct 17, 2008 2:32 am Post subject: |
|
|
Novice
Joined: 14 Oct 2008
Posts: 10
|
"A channel won't commit persistent messages onto target queue (or DLQ) until BATCHSZ number of messages completes or BATCHINT expires."
 Yuppie!!! Thanks for the answer. I was stuck because I was not even able to identify the problem. But how do I solve this problem 
Sapna |
|
| Back to top |
|
|
| gs |
| Posted: Fri Oct 17, 2008 3:57 am Post subject: |
|
|
Master
Joined: 31 May 2007
Posts: 254
Location: Sweden
|
"dspmqtrn" will give you information about any transactions in-doubt and "rsvmqtrn" lets you handle them.
However, be careful since this takes transaction security for the messages out of play. |
|
| Back to top |
|
|
| David.Partridge |
| Posted: Fri Oct 17, 2008 4:00 am Post subject: |
|
|
Master
Joined: 28 Jun 2001
Posts: 249
|
The messages *should* be committed when the tranmission queue at the sender end empties or after the current batch is completed. BATCHINT doesn't normally apply as the default is zero which means that it doesn't time out.
_________________
Cheers,
David C. Partridge |
|
| Back to top |
|
|
| sapna |
| Posted: Tue Oct 21, 2008 5:05 am Post subject: |
|
|
Novice
Joined: 14 Oct 2008
Posts: 10
|
But how do I commit the messages on "Dead Letter Queue". These messages are not put by the application but the queue manager.
Regards,
Sapna  |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Oct 21, 2008 8:32 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| sapna wrote: |
But how do I commit the messages on "Dead Letter Queue". These messages are not put by the application but the queue manager.
Regards,
Sapna |
They are still put by an application. The application however in this case is most probably the channel agent. Stop the sending channel and uncommitted messages should go away. The trick here is that it is most probably not the same messages that you see that are uncommitted. If the channel is running you are looking at a very fast moving target.
Enjoy
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
