Old Transactions in STARTED State

Hi all. We're currently seeing about 150 transactions in STARTED state with old Creation Times, up to about 10 days old. (This is when you do an imqcmd list txn). We suspect that a failure in our app is causing this -- we've had it crash a couple of times in the last 10 days and the date/times on the transactions agree with the crash times.

However, how can we now get rid of these transactions? If they're STARTed we can't use imqcmd because the txns must be PREPARED to commit or rollback.

So, 2 questions really:

* Has anyone seen this behaviour?

* Does anyone know what causes this behaviour?

* How can we get rid of these transactions?

OK, so 3 questions. Nobody expects The Sp...

[741 byte] By [kibitzer] at [2007-11-13]