Hi all,
I'm writing an application which access an IDS 9.31 database, using
Java/JDBC. I'm hoping someone can give me some advice on monitoring my
transactions and in particular looking out for potential long
transactions and the nightmares this can cause :-).
Up until now the app in question has been read-only running at the
lowest transaction isolation level so this hasn't been much of a
problem, but now I'm performing updates as well so have had to bump up
the isolation and start worrying more :-).
Obviously I'm being religous about closing resultsets and commit()ing,
but we all make mistakes :*). I'd like to be able to monitor what
transactions my application has open pending commit/rollback at any
given time (and as a side note what locks it may be holding as well.)
I'm using onstat (-x etc.) as best I can to work out what's going on,
but was wondering if there were any other tools out there that may be a
little easier to fathom, or even if not, if there were any
tips/tricks/advice I might benefit from!
Thanks in advance,
Tim.