OnArchive and logging
Posted in 1997
Topics: Backup & Restore, Storage & Space Management
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. 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? Any insight is appreciated. Thanks. Debbie Shelton DBIntellect