| Author |
Message
|
| slonkoski |
 Posted: Thu Mar 23, 2006 7:13 am Post subject: Any command to verify outstanding UOW? |
 |
|
Acolyte
Joined: 18 Mar 2005
Posts: 52
|
I'm trying to detrmine if a putting is committing messages. I tried dspmqtrn but that shows nothing, which makes sense, the messages aren't in doubt. We have a tool to check API calls, all I see the app doing is MQOPEN, MQPUT/GET, the MQCLOSE, so I assume the messages are uncommitted but would like to verify it 100% (the programmer doesn't know) any ideas?
Last edited by slonkoski on Thu Mar 23, 2006 7:38 am; edited 1 time in total |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Mar 23, 2006 7:29 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Does the queue depth increase, but the number of visible messages stay the same?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| slonkoski |
| Posted: Thu Mar 23, 2006 7:42 am Post subject: |
|
|
Acolyte
Joined: 18 Mar 2005
Posts: 52
|
| Yeah, I see the depth increase, but can't browse the messages, I assume they are uncommited, but want to verify that. |
|
| Back to top |
|
|
| mvic |
| Posted: Thu Mar 23, 2006 7:48 am Post subject: |
|
|
Jedi
Joined: 09 Mar 2004
Posts: 2080
|
| slonkoski wrote: |
| Yeah, I see the depth increase, but can't browse the messages, I assume they are uncommited, but want to verify that. |
Why do you need to verify this?
Have the programs for this queue all disconnected? What do you see after they've all disconnected? |
|
| Back to top |
|
|
| slonkoski |
| Posted: Thu Mar 23, 2006 7:57 am Post subject: |
|
|
Acolyte
Joined: 18 Mar 2005
Posts: 52
|
I'm working with the app programmer, this is a JMS app, as far as I know not issuing an MQCMIT call. I am pretty sure the UOW is left open and the programmer wants to know 100% if it is and I don't know how to check. I don't think his connection does a MQDISC, but gets thrown back to the pool and I assume the outstanding GET under syncpoint remains.
Make sense? I'm in over my head here but trying to learn |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Mar 23, 2006 7:58 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| slonkoski wrote: |
| Yeah, I see the depth increase, but can't browse the messages, I assume they are uncommited, but want to verify that. |
Consider it verified.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| slonkoski |
| Posted: Thu Mar 23, 2006 8:00 am Post subject: |
|
|
Acolyte
Joined: 18 Mar 2005
Posts: 52
|
| kinda thought so, thanks! |
|
| Back to top |
|
|
| mvic |
| Posted: Thu Mar 23, 2006 8:08 am Post subject: |
|
|
Jedi
Joined: 09 Mar 2004
Posts: 2080
|
| slonkoski wrote: |
| I'm working with the app programmer, this is a JMS app, as far as I know not issuing an MQCMIT call. |
JMS commit rules are complicated because there are several ways to create a Session, with different commit rules.  If the Session is transacted, you need to call Session.commit(). If the Session is client-acknowledge, you need to call Msg.acknowledge() - check the JMS spec.
Under the covers, MQ's JMS classes call MQCMIT at the appropriate time. But if the user is expected to call Session.commit() or Msg.acknowledge() by the JMS spec, then MQ will not call MQCMIT on the user's behalf.
| Quote: |
| I am pretty sure the UOW is left open and the programmer wants to know 100% if it is and I don't know how to check |
Run an MQ or JMS trace and verify for sure exactly what JMS calls and MQI calls are being made.
| Quote: |
| I don't think his connection does a MQDISC, but gets thrown back to the pool and I assume the outstanding GET under syncpoint remains. |
OK by now there are too many 'I assume's. Time to get a trace and verify what is really going on.  |
|
| Back to top |
|
|
| slonkoski |
| Posted: Thu Mar 23, 2006 8:14 am Post subject: |
|
|
Acolyte
Joined: 18 Mar 2005
Posts: 52
|
| Thanks, I'll take the advice and stop assuming. I'll work with the developer and get to the bottom of this, first and formost I need him to answer some questions for me about how jms behaves. |
|
| Back to top |
|
|
| wschutz |
| Posted: Thu Mar 23, 2006 8:41 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
btw..the "display qstatus(x) type(queue) displays whether there are "UNCOMmitted" uow's on the queue.
_________________
-wayne |
|
| Back to top |
|
|
| slonkoski |
| Posted: Thu Mar 23, 2006 8:54 am Post subject: |
|
|
Acolyte
Joined: 18 Mar 2005
Posts: 52
|
|
| Back to top |
|
|
|
|
