tags:

views:

230

answers:

1
Q: 

How to find long running transactions in Websphere MQ Series?

In a J2EE environment the MQ server log shows the following:

Process(954584.5) User(mqm) Program(amqzmuc0) AMQ7469: Transactions rolled back to release log space. ....

While increasing the logfile size/space might be a temporary solution, the definitive solution must be to identify the culprit process/queue that causes this long transaction.

Is there any solution/tool for this?

Note: MQ is used via JMS only

A: 

You want the DISPLAY CONN TYPE(CONN) ALL command, paying attention to the UOW* attributes. See: http://publib.boulder.ibm.com/infocenter/wmqv7/v7r0/topic/com.ibm.mq.csqzaj.doc/sc11950_.htm

T.Rob  2010-03-31 01:28:52

related questions

transaction isolation problem or wrong approach?
SQL Server 2000 and System.Transactions.TransactionScope()
How do I use a remote MSMQ transactionally?
Distributed Processing: C++ equivalent of JTA
What is the 'best' way to do distributed transactions across multiple databases using Spring and Hibernate
When do transactions start when using (restful) rails
IsolationLevel.RepeatableRead to prevent duplicates
EJB3 Transaction Propogation
Properly scoped transactions in Stored Procs
SQL Server sys.databases log_reuse_wait question
When do transactions become more of a burden than a benefit?
How to prevent an Insert query from enrolling into a Distributed Transaction?
JPA Multiple Transaction Managers
What are the problems of using transactions in a database?
Wrap an Oracle schema update in a transaction
Nested SQL Server transaction performing cascade delete
Update schema and rows in one transaction, SQL Server 2005
How do distributed transactions work (eg. MSDTC)?
Looking for a SQL Transaction Log file viewer
Propagation of Oracle Transactions Between C++ and Java
Is SQL Server Bulk Insert Transactional?
Transactions best practices
Transactional Design Pattern
Is it possible to share a transaction between a .Net application and a COM+ object?
Unit-Testing Databases