Re: logical log cannot be freed

Posted in 1997

David Williams — Fri, 13 Jun 1997 23:34:19 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <5nqpsl$rgg@cssun.mathcs.emory.edu>, Pranadjaja <prana@rad.net.id> writes > >Hello Peter ! > >I don't think that "UB" means free. When Informix stoppped processing, we >backed up all logical log files and then brought it online again. We could >not run our applicaiton again. The status of logical log files remains >"UB" not "F". Infomrix stopeed processing again. > > >Pranadjaja > Correct it has to be UB AND not contain any logical log records from a currently active transaction i.e. one that has not been commited or rolled back. Try decreasing the long transaction gith watermark and long transaction exclusive high water mark. You may need them as low as 30 and 40... -- David Williams