MQSeries.net :: View topic - try to underatsnd DFE unit of work

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » try to underatsnd DFE unit of work

try to underatsnd DFE unit of work

« View previous topic :: View next topic »

Author

Message

KIT_INC

Posted: Thu Dec 14, 2017 10:16 am Post subject: try to underatsnd DFE unit of work

Knight

Joined: 25 Aug 2006
Posts: 589

I am running IIB V10 on AIX. When I display connection under the Qmgr, I saw

Code:

AMQ8276: Display Connection details.
CONN(5A0FF5A120056661)
EXTCONN(414D51435049494253444D3120202020)
TYPE(CONN)
PID(11272200) TID(16)
APPLDESC( ) APPLTAG(DataFlowEngine)
APPLTYPE(USER) ASTATE(STARTWAIT)
CHANNEL( ) CLIENTID( )
CONNAME( )
CONNOPTS(MQCNO_HANDLE_SHARE_BLOCK,MQCNO_SHARED_BINDING)
USERID(mqm) UOWLOG( )
UOWSTDA(2017-12-08) UOWSTTI(21.11.17)
UOWLOGDA( ) UOWLOGTI( )
URTYPE(QMGR)
EXTURID(XA_FORMATID[] XA_GTRID[] XA_BQUAL[])
QMURID(0.98613705) UOWSTATE(ACTIVE)

The UOWSTATE(ACTIVE) says that the UOW is active. The UOWSTDA(2017-12-08) UOWSTTI(21.11.17) is the start date and time of the UOW. Today is 12-14. Does this mean that I have a long running transaction which started the UOW at 21:11.17 on Dec 08 and there was no commit so far (still active). My understanding is a message flow is a UOW which starts when it picks up a message from the input to process and commit the UOW when message output is completed. The connection says DFE and not message flow. I am just trying to understand what this really means. Do I really have a long running transaction under the DFE since 12-08 ?

The reason I am asking is because our MQ admin notice a few of this messages recently and the PID of the roll back transactions are DFEs ( not the one I posted here). We had a restart since then and hence I cannot track down the DFE that was suppose to cause the error message

"AMQ7469 or AMQ7485 has been issued indicating if the transaction was rolled back or rolled forward in the log to allow the log space to be released. "

abhi_thri

Posted: Fri Dec 15, 2017 1:26 am Post subject:

Knight

Joined: 17 Jul 2017
Posts: 516
Location: UK

Hi...that is just showing the connection handle to the queue opened by the DFE, i.e it looks like the flow was restarted on 08-12-2017 and it won't close the connection until the flow is stopped, so nothing to do with any long running transaction. If the DFE has say 10 flows listening to 10 different queues you should be able to find 10 different connection handles,

try with 'display conn(*) WHERE (pid EQ <pid>)' and see

If you suspect long running transaction for any particular flow try monitoring the queue status and see, 'Uncomitted messages' property will remain stuck at 'Yes' and you will see messages building up on the queue.

Regards, Abhi

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » try to underatsnd DFE unit of work

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