RE: updates during ontape

Posted in 1999

Rock, Howard — Fri, 2 Jul 1999 15:09:43 -0400 — source: Informix-list mailing list archive (1991-1998)

If I am not mistaken an Informix Archive takes A snapshot of the data when the Archive starts so I believe it will have NONE of the rows updated in the update job Howard E. Rock Informix Database Administrator Insurance Services Office 2 Blue Hill Plaza Pearl River, NY 10965 Email - <mailto:hrock@iso.com> hrock@iso.com Telephone # 914-620-4088 Fax # 914-620-4050 ---------- From: Justin Abbott [SMTP:abbotj@my-deja.com] Sent: Friday, July 02, 1999 12:19 PM To: informix-list@iiug.org Subject: 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. Also, how does Informix decide where in the log a level 0 archive is taken, is it at the start or at the end? regards Justin Abbott Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.