Re: AGAIN: Cannot start Online Engine

David Kosenko (davek@ginformix.com) wrote: : Tbzero is no panacea, and would not work in this case. Tbzero will locate : the last checkpoint entry in the log and modify the value for number of : active transactions to 0. This has the effect of tricking tbinit into thinking : there are no transactions to rollforward, so the logical recovery is : essentially : skipped. Since tbinit is unable to locate a checkpoint record in Richard's : online system, there is no identifiable checkpoint record for tbzero to fix. David, your explanation sounds very reasonable and logical. Nevertheless, tbzero solved my problem. It took only a few seconds to run, and afterwards, the engine came up without a glitch. I was able to unload all the tables I needed. Since I unloaded complete tables, I guess no indices were used and therefore possible index corruption didn't matter. I didn't bother doing a tbcheck since I will not use those databases any more. Regards, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+