Re: deadlock: logical log full

If all the logs are FULL, I think you have no solutions, the engine didnt allow you to backup or do anything. I heard that Informix Tech Support has a tool for solving it. Otherwise, you have to re-initailize and restore your data Nien -----Original Message----- From: Greg Moye <greg.moye@eds.com> To: informix-list@iiug.org <informix-list@iiug.org> Date: Wednesday, June 24, 1998 10:41 ' Subject: Re: deadlock: logical log full >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