Re: tbinit without logical recovery ??

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)