Re: Un-attended Large Archives (fwd)

Graeme Sargent (graeme@pyra.co.uk) wrote: : But what does this do to your Fast Recovery times??? We are trying to : implement highly available systems here. We frequently get asked to : provide recovery times after powerout of the order of 3 minutes. Since : the system requires longer than this to boot and fsck, every second I : can save on Fast Recovery is valuable, thus it is tempting to *increase* : checkpoint frequency to the 30 - 60 second range. : I get the impression that this tape change/lockup problem is perceived : as relatively low priority by Informix, whereas it is a *BIG ISSUE* for : us, and I'm sure for any large site. What is the point of having an : Online Archive facility if using it freezes your system as soon as you : go beyond one tape unless your tape operator a) is on his/her toes and : b) has nothing else to do??? I usually try not to stick my foot in my mouth, but this time, well, I can't help it. What dave basically said was that changing the check point interval can help reduce this problem. If you have other needs (I could not tell from your original posting that you had a time recovery criteria), there are other solutions. How about buying a 5 gig tape drive. If that is too small, buy a jude box that can go to 100 gig. Yes... The same old story. throwing money at things, usually solve the problem. dshirazi@uhl.uiowa.edu : graeme : -- : Disclaimer: The author's opinions are his own, and not necessarily : those of Pyramid Technology Ltd. or Pyramid Technology Inc. : --------------------------------------------------------------------------- : -m------- Graeme Sargent Voice: +44 (0)252 373035 : ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 : -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? : -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@uk.pyramid.com : --------------------------------------------------------------------------- : We have the technology. The tricky bit is learning how to use it. : operator