Subject Re: Problem - growing DB size
Author Svein Erling Tysvær
Then I would expect the oldest active transaction to be one higher
than the next transaction. Another thing you could do, is to try to
rename the database file. If someone is accessing the file (including
you), you will be denied. Though I guess that means no connections,
not only no transactions. Also, tools like IB_SQL (freeware, can show who is connected. It will at least show
you as connected, since you must be connected to get that information
and it doesn't say anything about transactions (though if you didn't
do any DML in IB_SQL and only find your connection, then you know that
there ain't no uncommitted transaction that is causing problems.


--- In, "mysha_cz" wrote:
> There is no way to find out, that no one transaction is actual open?
> ..if i have db, on local pc, only for me, no other users are
> connected, no activity...
> --- In, Svein Erling Tysvær wrote:
> >
> > Just check that the gap between the oldest active transaction and the
> > next transaction is not too big.
> >
> > Set
> >