Hopefully somebody can offer a better way, but thus far the only way I've
seen to get any kind of transaction information is to go through the IB
Server Console and get the database statistics. This will at least let you
see if a transaction somewhere is preventing the OAT from advancing.


FWIW


Bill M

-----Original Message-----
From: kyle@... [mailto:kyle@...]
Sent: Wednesday, October 24, 2001 8:12 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Monitoring open transactions


Is there a straightforward way to get a real-time display of what
transaction are active in an IB database? I want to run such a thing
and keep an eye on a few Interbase applications to see what they are
doing, see if they are keeping transactions open longer than
necessary.

Is this something that would have to be done at the IBO level (it
certainly seems possible to build with the IBO Monitor component), or
could I somehow monitor an entire IB server / non-IBO applications?

Kyle Cordes
www.kylecordes.com



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/