RE: informix and SAN snapshot
onbar is similar to ontape - they are both backup tools for taking a
backup of the database engine.
Neither utility has SAN knowledge / concepts build in.
Have a read of the backup and restore guide here
http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.bar.
doc/bar.htm.
It is for version 11.50, but the guts are the same as version 9.
Also - which version of 9 is it? 9.0 was very different to 9.2 and then
there were major advances on 9.40
-----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/