Re: Fast Recovery Forever !!

SH Lim wrote: > > Guys and Gals, > Could you help me out here. I need some good solid explanation that > can convice management (non-techies) with high expectations about > Informix. > The Online Server 7.13 configured with care and which has been > runnning for weeks suddenly went into Fast-Recovery mode automatically. > We waited for checkpoints, etc to be completed but it was unable to go > Online for the next 30 minutes. > Finally, a decision to re-initialize it was done and work continued > as usual. > The only explanation that was available at that time and since then, > was that a deadlock probably happened on one of our most referenced > table. > Would there be any other explanations for this ?? Fast recovery is initiated when OnLine comes UP. Therefore, OnLine must have gone DOWN. You need to check the message log for the reason. Deadlocks in themselves do not cause OnLine to go down. Hope that helps, -- Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+