Re: deadlock: logical log full
Posted in 1998
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