Re: HELP - Logical Logs are full - Online halted
Posted in 1999
On Wed, 28 Apr 1999, Thomas G. Smith wrote:
> I believe it's tbtape -r time -- you need to restore from your last level 0
> archive. I know of no way around this with version 4.x of Informix. Anyone
> else?
>
> zigzag@infi.net wrote:
>
> > Can anyone assist with the following problem:
> > 1) Very long transaction aborted (loading of large table)
> > 2) Appears that logical logs are completely full and transaction can not
> > roll back.
> > 3) Informix Online was taken offline and restarted
> > 4) Online will not "recover" from recovery mode.
> > 5) tbstat -m (log file display) says logical logs are full and need to
> > backed up.
> > 6) can't get online to quiescent mode or to online mode.
> >
> > This Online 4.1 Engine running on ISC Unix.
> >
> > Please help. Production system has halted.
> >
> > ZZ
>
You would normally run 'ontape -a' to clear the logs immediately.
John