The DB-Statistic of my DB looks like
Oldest transaction 1493
Oldest active 1549
Oldest snapshot 1549
Next transaction 1557

I want to close the gap between Next transaction and OAT, so I tried a
sweep, but this doesn't help. Then I tried a transaction recovery, but I
get the message, that no pending transactions werde found.
I know, I can close the gap with backup and restore, but exists no other
way ?
What is a sweep exactly doing ?

I know, that the gap between Next transaction and OAT comes from
disconnecting from the server without commiting all transactions, but
what is the reason for the gap between OAT and OIT ?

BTW, I'm using IBO with AutoCommit for all transactions, so I thought
the problem with OAT and Next transaction wouldn't occur, does anybody
know, what I have forgotten ?


Guido