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. "
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.
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