Subject Re: database sweeps
Author Aage Johansen
Jan Agermose wrote:
> I will try that. We do backups every night - sweeps are done during
> backups as I understand. How about the numbers. If all querys are
> autocommited should the "oldest trans." not follow the "next trans."
> number by a margin of "the number of currently open connections"?


Are you sure nothing is holding up a transaction? Do you monitor progress
with an open transaction (e.g. in IBConsole)?


Regards,
Aage J.