Re: How to 'clear' the full log dbspace?

On Mon, 20 Jan 1997, alex wrote: > Hi, > > I'm using Informix Online 5.01 on the SCO 3.2.4. > > Yesterday I executed an big transaction process that exceeded my log > volume, the log was full and everything halted, then I killed the process > and use 'tbstat -l' to check my log info, finding that almost all log space > are 100% full, when I use 'tbtape -s' to backup(the tape device pointed to > /dev/null) the log, but the program waits forever... and online server > could not be brought to online or quiescent mode, only the recovery mode. > > Under this situation, how can I init the logspace and bring the server to > normal state? > 2 options: a) Restore from tape and lose all data since your last archive (DON'T rollforward logical logs) - this is what the manual says - it sucks. b) Get Informix support to dial in. They have a routine that can retrieve this situation. Not documented (at least in version 5). HTH, Richard.