Re: AGAIN: Cannot start Online Engine

Jim Burks writes: |> Richard Spitz says: |> >17:39:55 INFORMIX-Online Initialized -- Shared Memory Initialized |> >17:39:55 Physical Recovery Started |> >17:39:55 Checkpoint Completed |> >17:39:55 Physical Recovery Complete: 0 Pages Restored |> >17:39:55 Checkpoint Record not Found in Logical Log |> >17:39:55 Cannot Rollforward from Checkpoint |> >17:39:55 INFORMIX-Online Stopped |> |> Otherwise, call Informix Technical Support and ask for "tbzero", |> denigrated elsewhere in this forum. It will cause Logical Recovery |> to be skipped for this recovery, and MAY (probably) cause some |> consistency checks in data and indexes that were being updated |> when the archive was taken. The good news is that if you are |> unloading all rows, the system will skip on past bad pages, and |> will not use the index. 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. However, calling tech support in this case is not the worst idea. Dave Disclaimer: The opinions expressed in this message are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. **************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney