Re: Error initializing Informix-Online

Enrique Zubir'a wrote: > In an old Informix Online 4.10 we have got this error: > 1- The computer was turned off with INFORMIX running > 2- After that, when I try to initializing Informix Online to quiescent mode > tbinit answer: > 'tbinit: fatal error in shared memory initialization' > Shared memory not initialized > 3- the system log file says: > INFORMIX-Online Initialized -- Shared memory Initialized > Physical Recovery Started > Checkpoint completed > Physical Recovery Complete: 0 Pages Restored > Transaction Not Found > Log Record: log = 3007, pos = 4b018, type = 51, trans = 2 > Cannot Rollforward from Checkpoint > INFORMIX-Online Stopped > > 4- That's all. What can I do? My only idea is to reinstall INFORMIX-Online > and recover the databases from a backup ( and old one :-( ) Any other > suggestion? This is the danger of using Buffered Logging. An incomplete set of logical log records was written and fast recovery does not know how to recover. Tech support should be able to delete the offending partial transaction and let the engine come up. If they cannot you will have to restore. I hope that you have your log backups also. BTW you do not have to reinstall Informix or initialize the database. Just run tbtape -r while the engine is offline, tbtape will restore the reserved pages and bring up the engine then restore the rest of the dbspaces. Let tech support take a crack at it first though, and change to unbuffered logging. Also put tbmode -ky into the shutdown scripts for run-level 3 (or whatever your normal runlevel is) to reduce the number of ways to trash the engine, this way only a hard powerdown can hurt you. Art S. Kagel