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

In article <5bvhl8$odo@cssun.mathcs.emory.edu>, Richard Thomas <richardt@TheMusicStore.co.uk> writes > > >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. > Yeap! >b) Get Informix support to dial in. They have a routine that can >retrieve this situation. Not documented (at least in version 5). > It is an internal use only tool (can't remember the name of it). It rools everything back to the last cheeckpoint. i.e. does the rollback part of fast recovery but not the roll forward of transactions commited since the last checkpoint. People at customer sites have been fired for allowing Informix to do this hence they do not release it to everyone. >HTH, > >Richard. > -- David Williams