<lester@...> wrote in message news:3C4819A3.64716590@......

> > 1. Why restart the server can bring down the OAT/Next Transaction gap
> > without doing backup/restore or sweep ?.
>
> If applications are holding it open, perhaps some particular
> window in an application.

This should not be the case, since user stay on their app. all day long and
sometime the problem can clear itself when load is slow down. It seems FB is
too busy to clear up its garbage and it lock up itself -- I may be wrong.

> > 3 We set sweep interval = 20,000. Would it help if we set sweep

interval to

> > 3,000? Will the sweep process clear the OAT/Next Transaction gap?.
>
> Set it to 0 and run sweep at night when it's quiet. Then it
> WONT happen just as you get busy <g>

If we set it to 0, will the system slow down after a period of time? since
the OAT gaps keeps growing.

> > 4 The Application use IBO with AutoCommit transaction. If the explicit
> > transaction is used it is always end with Commit or rollback. Can

Rollback

> > contribute to this problem?
>
> Switching to IBO cleared all my BDE related transaction
> problems, so it's unusual for something to stay open. I
> would still suggest that may be the problem.

Do you mean ROLLBACK can cause the problem? or open transaction is the
problem? (which I try very hard to find in the app. any open transaction and
still don't want to believe that the app. has some open transaction

Thanks for the answer,
Jim Sirikolkarn