ok, I have a problem with interbase 6.0.2.0 / Delphi 5 / BDE, wondering
if FB solves it or helps.....

I cannot replicate or find how my apps are doing this but on occasions I
have a header statistics from the database as follows;

OT 566738
OAT 566739
NT 940551
OS 564916

Even if I log all applications out the transactions do not catch up with
themselves.. So my question is I am seriously considering moving to FB
1.5 once it is in full release, is there a way that I can type in the
oat and get rid of the transaction so that the Transactions all catch up
? I have tried with interbase to use the gfix -commit [trans number] and
it just says that the transaction is active, even if I have no
connections to interbase. This seems to happen every week and a backup
and restore this regularly is not an option for them.

Wouldn't it be nice to have a command that you can run that just resets
all transactions and memory allocations, so if you know that no-one on a
site is connected and doing anything to your database you can just say
right, lets set IB/FB as though we have done a backup and restore and
start from the beginning again.. the reason this would be nice is that
this problem is seriously degrading performance at the site....

Can anyone offer any advice... at my wits end here....

TIA

Martin Dew


[Non-text portions of this message have been removed]