Re: deadlock: logical log full

Hi Greg, hi Andrew, thanks for your help. onmonitor seems to be an UNIX Informix Command, it doesn't work on Informix on NT. The log tape device is set to hard disk. The system is not able to make an ontape -a --> Error: backup failed I tryed to set the log Tape device (ONCONFIG) to NUL, -->error: it's not allowed to have NUL for the log tape device How can I see if a long transaction has accured? If I delete the DBspace, will the log file than be freed??? (I have the chance to make a dbimport of my Database) Thanks for helping, Heike Andrew Mercer <amercer@wsl.com.au> schrieb im Beitrag <359192e0.0@cactus>... > > Greg Moye wrote in message <3591114A.6365@eds.com>... > >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...). > ^ > | > For Informix on NT use NUL - /dev/null is for Unix > > > > > >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 > > >