Art S. Kagel wrote:
> The ONLY way: Call Informix Tech support and they can log in and
> truncate the logical logfiles so that the engine thinks the log ends
> at the beginning of log file with the last checkpoint. Then you can
> bring the engine up. You do need to go through logical recovery anyway
> since there will be open transactions from before the checkpoint that
> the physical recovery cannot overwrite and which must be rolled back.
(yeesh, here I go again)
Actually, when Tech Support truncates the logfiles, it makes the engine
think the log ends *at* the last checkpoint, and they also zero out the
open transaction count in the checkpoint, so that it thinks there is
nothing to roll back. That is expressly for situations like this, where
logread() causes logical recovery to fail either on rollforward or
rollback.
June
--
june_t@hotmail.com
Grounded in Palo Alto, living on M&M's (plain)