Re: Stupid DBA tricks

Posted in 2001

Mario R. Canto — Tue, 30 Jan 2001 10:25:50 -0300 — source: Informix-list mailing list archive (1991-1998)

Michael Hoffman wrote: > > Needless to say, this time when the Long Transaction hit, it didn't > bomb the load, but instead hung the DB. The online.log message read "Waiting > for Next logical Log". Trouble with a Capital T! I couldn't force a > checkpoint because the logs were totally full. I tried 'ontape -a' but got an > error "LogBackup to /dev/null not allowed". I'm assuming that this is also > because there were no free logical logs to write out the fact that an archive > was being performed. You may create a link in /dev like "/dev/nully" pointing to /dev/null an then use it as a logical log backup device. > > Thanks, > Michael Hoffman Byte byte! -- Mario R. Canto mcanto@4m.com.ar mcanto@intec.unl.edu.ar mcanto@intec.arcride.edu.ar http://www.intec.unl.edu.ar/~mcanto