Subject Re: [IBO] OAT
Author Svein Erling
Yes Paul,
I'd say you do have a problem. I do not know how many transactions
your system use each day, but I'd guess way below 700000. Hence, there
is one transaction that was started days/weeks/years ago that still
has not been committed.

My guess is that this is not a read-only transaction, since it is easy
to teach people that they have to commit for their changes to be
visible. Maybe someone is monitoring your system, never turning their
computers off?

You also have another problem that you do not know about: OAT issues
has nothing to do with IBO, so you should move this subject over to
the ib-support forum.


--- In, "Paul Hope" wrote:
> Hi
> I suspect I have OAT problems and would appreciate some help as to
> where to look.
> This is an extract from DB Stats
> Oldest transaction 983067
> Oldest active 983068
> Oldest snapshot 983067
> Next transaction 1752712
> If this is OK then I can stop worrying, however I think it means
> that there are some 770,000 transactions active - which doesnt sound
> reasonable :-(
> The default transaction is set to AutoCommit and ReadCommitted.
This is used by
> - All read transactions
> - All trivial single update transactions
> All multiple updates use their own IB_Transaction (not AutoCommit,
ReadCommitted) and the code contains a StartTransaction and
Commit/Rollback in a try/except block. There is never any oportunity
for the user to hold up the process between the two.
> Forms that do not use data aware components are loaded using an
IB_Cursor with everything as default except for the IB_Connection and
the SQL. I will call First, read the data to EOF, then probably
leave the IB_Cursor and let it be destroyed with the form.
> Forms that do use data aware controls use the IB_Query with update
SQL and the default transaction. Some of these use grids, and some of
those are master detail connected to potentially large tables.
Sometimes the forms have their own AutoCommit transaction object.
> Any suggestions as to how I go about sorting this would be greatly
> ( IB 5.6, D6, IBO4.2Ie)
> Regards
> Paul