I suggest you build into your application a little check to look at
transactions and see how long they are going. The IB_Session component in
apps has a list of all transactions for the session and you can examine the
transactions's start time. I can't remember the name of the property but it
is intuitive.

You can also use the TIB_Status dialog to simply launch a form that knows
how to exploit all the information and display it to you. It's a way of
peeking in under the hood and investigating all problems that may be taking
place in your IBO apps. If the apps are non-visual designate a log file that
suspect information can be dumped into.

IBO has a lot of mechanisms to help avoid OAT problems but there are still
measures and points of consideration you need to take. I have written much
on this in the past so please read archives, FAQ's and so on.

Thanks,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Rolf Bredemeier" <rbredemeier@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Friday, April 05, 2002 12:50 AM
Subject: [IBO] transaction question


> Dear list,
>
> we use for our applications InterBase 5.6, IBObjects and, in some older
> programs, BDE.
>
> Now i discovered a large gap between the oldest interesting transaction
> and the next transaction.
> At this time server statisitc reported
> oldest transaction 9477
> aoldest active transaction 9478
> next transaction 13205 // not ok, isn't it?
>
> How can i get some information of the oldest transaction?
> Because, the InterBase server is uses by 45 clients and round 130
programs...
> Of course, i take a look in the programs, but i cant find the application,
> that makes the trouble. Seems all is ok...
>
> In the night, in a batchrun, after last user logs out, i make a sweep an
the gap
> shrinks, it's ok then. But, during the next day, the gab occours again.
>
> Can i get a piece of advice for this?
>
> Best regards and many greetings, Rolf