RE: informix and SAN snapshot

This is the link to the version 9.4 backup and restore guide http://publib.boulder.ibm.com/epubs/pdf/ct1slna.pdf -----Original Message----- From: Vince Tai [mailto:vincetai@icon-info.com.hk] Sent: Tuesday, 25 November 2008 4:26 p.m. To: Jarrod Teale Cc: Vince Tai Subject: Re: informix and SAN snapshot Dear Jarrod, Thanks for your reply. However, when should I use the command "onbar"? Thanks. Regards, Vince "Jarrod Teale" <Jarrod.Teale@fonterra.com> wrote in message news:<mailman.384.1227581363.874.informix-list@iiug.org>... You can block the database using "onmode -c block" - it causes the database to enter a checkpoint and wait for you to issue the "onmode -c unblock" command to let the database proceed. This will block all transactions while you are doing the snapshot though - no caching etc and users will get error messages when they try to do anything. Jarrod Teale Fonterra NZ. ________________________________ From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of vt Sent: Tuesday, 25 November 2008 3:20 p.m. To: informix-list@iiug.org Subject: informix and SAN snapshot Hi all Informix experts, i would like to put the Informix DB v9.x on SAN and take snapshots daily so that in case there is data corruption, I can rollback to previous version. However, I found Informix is a bit different from Oracle and Sybase as they have backup modes but Informix doesn't have. (Correct me if I'm wrong) I did do some researches on the Internet and found a utility called onbar. Can I use this command to temporarily freeze the DB before I take a snapshot on the SAN so that the snapshot taken will have no integrity issue? If so, during the snapshoting, where will the new transactions go? Will the new transactions be temporarily stored on somewhere else? Thanks a lot in advance. Regards, vt ---------- DISCLAIMER: This email contains confidential information and may be legally privileged. If you are not the intended recipient or have received this email in error, please notify the sender immediately and destroy this email. You may not use, disclose or copy this email or its attachments in any way. Any opinions expressed in this email are those of the author and are not necessarily those of the Fonterra Co-operative Group. http://www.fonterra.com/