Re: OnArchive and logging

Debbie Shelton wrote: } I need to know if what we want to do will work... } } Here's our situation: } SGI, Informix OnLine 7.20, 400GM of Informix data and index space, 2 GB } RAM } } We will have some VERY HEAVY insert/update processing on the system over } the weekends and would like to turn logging off to increase processing } throughput. } } Here's what we want to do: currently we have logging on, use OnArchive } to archive different dbspaces to different tapes, turn logging off, } processes the large amount of data, then turn logging on and do a level } 0 archive off all dbspaces and continue normal processing. I've done } this without any problems using OnTape, but I'm unsure how OnArchive } will deal with this. No problem. } Also, we're a little concerned about there being } problems during the weekend processing and having to restore from the } archive prior to turning logging off. } } What are the recovery impacts of turning logging off prior to the } weekend processing? Are there any special considerations we should be } aware of? You can turn logging on quickly with ontape with /dev/null settings at any time. As I know, onarchive can't work with /dev/null. But it seems to me that you doesn't worry about weekend problems, since you already done that type of work. } Any insight is appreciated. Thanks. } } Debbie Shelton } DBIntellect Vardan -- vardan@sterling.ru Vardan Aroustamian Sterling Group, Moscow, Russia