Re: deadlock: logical log full
Posted in 1998
Use onmonitor to set the logical log tape device to wherever you want to
write the logs (use /dev/null if you don't need to keep them...).
Then run as user informix "ontape -a"
This will write all used logs that are not part of a long transaction to
tape, freeing them for future use. The hung processes then should take
off running again, fat, dumb and happy.
You don't have a long transaction that spans all of the logs do you??
If so, get out your archive tapes, you're hosed.
greg
Heike Heilbronn wrote:
>
> Hi
> I work with Infomix Online Server 7.12 on OS Windows NT 4.0.
> I got the error LOGICAL LOG IS FULL
>
> now I am in the deadlock situation, because I have to backup the logical
> log.
> This is not possible because the next logical log file is already used.
> all log files are flaged U (used)
>
> how can I free the logical log ????
>
> Thanks for your Help
> Heike