Silly question.

Suppose I have a large table and I'm backing it up for a point in time archive.

The back up is done on a live system, so you have people inserting rows while the backup is running.

Will those rows become part of the back up?

An example... I start the back up at Midnight, and at 12:01, someone inserts a record.
What happens?

Thx

-G


__________________________________________________ _______________
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail.
http://www.windowslive.com/campaign/...M_HMP:042010_5

Well I guess it would be trivial if all you did was IDS. ;-)
Like I said it was a silly question ...



__________________________________________________ _______________
The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail.
http://www.windowslive.com/campaign/...M_HMP:042010_4

Hi,

Everything done before the archive checkpoint will be in the backup
itself.
Everything done after the archive checkpoint will be in logical logs -
which
you also should backup.

Hence, you can freely choose the point-in-time (PIT) for the restore
during restore time - it does not need to be decided/choosen at backup
time.

Obviously, the PIT should be at or after the archive checkpoint, but can't
be before.
Also obviously, the PIT should be before the time the last log that you
backed up
has filled. ON-Bar will then find and restore the necessary logs.

Some info on the advanced level (you may skip this for now and read it at
a later time): ;-)

A) If you have several backups done with ON-Bar ... it will even find
the correct
backup to start the restore with, depending on the choosen PIT.

B) There exists also the concept of transactions in IDS. If you have a
transaction that is at the time of the choosen PIT, the actions done
by
this transaction will be rolled back at the end of the restore. This
is to
reach a point of logical consistency. Interestingly, this will also
work
correctly, if the transaction started before the archive checkpoint
was
done!

C) Read more about PIT restore and backup/restore concepts in general in
the
appropriate manual: "Backup and Restore Guide".

Regards, Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management

IBM Deutschland Research & Development GmbH
Chairman of the Supervisory Board: Martin Jetter
Board of Management: Dirk Wittkopp
Corporate Seat: Boeblingen, Germany
Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294

informix-list-bounces (AT) iiug (DOT) org wrote on 06/22/2010 12:19:08 AM: