Re: updates during ontape

> Hi folks > (a theoretical scenario) > > John the dba starts an Informix ontape level 0 at 11:00am > At 11:20am a batch update utility starts. > At 12:00pm the ontape level 0 finishes > At 1:20pm the load finishes. > > The question is: > Will the ontape backup contain > 1. none > 2. some or > 3. all of the rows updated in the update job. None. > Also, how does Informix decide where in the log a level 0 archive is > taken, is it at the start or at the end? If I understand your question, you're asking if the archive reflects the state of the database when the archive started or when it ended. The archive is a logically consistent copy of the database as it existed at the time the archive started. Any transactions that were started but not committed when the archive began are rolled back after you restore from that archive. Thus, if your batch load started instead at 10:50am and did not commit until it completed at 12:50pm, you still would have no rows from your load after restoring from the archive. The manuals discuss how the physical log is used to make all of this work. Mark Collins mcollins@us.dhl.com