Hi Kevin

I notice that your post hasn't been answered so I thought I would try and
contribute a little.

I have the same problem with quite a large app that continues to grow but
has largely migrated from the BDE. I found I couldn't clear the OAT with a
sweep because it was 'stuck'.

One the causes I had was the IB_Cursor and the default(autocommit)
transaction doing a simple read some records into a client object. If it
is possible for an IB_Cursor to left open, because the user leaves a form
open where you don't close the cursor or and exception causes the close
command to be skipped then the OAT will get stuck. I have now put all my
IB_Cursors in a try-finally-close, this combined with setting the sweep
interval to 10000 has made it manageable for now. Alternatively I could
have used explicit non autocommit transactions in a
try-commit-except-rollback block but that was a lot more work.

I believe the reason why the transaction gap still grows (requiring the
sweep) is my use of TIB_Query, db aware controls and autocommit. I still
don't know if there is a simple solution to this - a hard commit will close
the data.

I would welcome a clearer understanding of the options so if anyone else
would like to illuminate please do . . . .

Regards
Paul

> -----Original Message-----
> From: Kevin Stanton [mailto:Kevin.Stanton@...]
> Sent: 15 July 2004 19:50
> To: IBO List
> Subject: [IBO] Transaction Advice Needed
>
> Greetings,
> I've written a very large application with IBO using both TDataset and
> Native controls.
>
> My main question to the IBO experts - is there a tool/component to help me
> track down what transaction is holding up the Oldest transaction and
> Oldest
> active from not being incremented.
>
>
> Right now, the statistics look like this:
> Database header page information:
> Flags 0
> Checksum 12345
> Generation 13237
> Page size 4096
> ODS version 10.0
> Oldest transaction 837
> Oldest active 838
> Oldest snapshot 779
> Next transaction 13229
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 0
> Implementation ID 16
> Shadow count 0
> Page buffers 0
> Next header page 0
> Database dialect 3
> Creation date Jul 14, 2004 22:25:15
> Attributes force write
>
> Variable header data:
> Sweep interval: 0
> *END*
>
>
>
>
> __________________________________________________________________________
> _
> 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 !
> Yahoo! Groups Links
>
>
>
>