Re: tbinit without logical recovery ??

June Tong wrote: > 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. > > 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. > Man from Informix.cz says something similar ... but ...they will not give me this extremely useful utility :-((( and they will not do it themselves in suitable time... For all: have you ever heard about problems with logread() logsearch() on OnLine 5.x ?? If you have, what did cause these terrific errors ?? Michal PS: I even found (somewhere on net) that 7.x has -p switch for tbtape which causes not doing logical recovery during recovery .. it is true ? -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz Sprava NIS http://www.nspuh.cz NsP Uherske Hradiste phone : voice +420 0632 529 204 Purkynova 365 fax +420 0632 551 014 686 68 Uherske Hradiste Czech Republic ICQ UIN: 14290832 --------------------------------------------------------------