oad done on a table with nonrecoverable option on a archive loging enabled Database

shiva359

Dear All ,
will changes done on a table data After a load with
nonrecoverable option on a archive loging enabled Database be
recorded in logs if we don't do a complete backup after
load ?

also curious to know on what would bedoing the effect if we do a
backup online after the load and do changes to table ( wihtout
doing a offline Backup ) .

If we restore the online Backup taken after the load ( with
nonrecoverable option) does the table be available and can continue
to record changes for that table in logs
with regards
shiva

Aug 30 '07 #1

Ian

sh******@gmail.com wrote:

Dear All ,
will changes done on a table data After a load with
nonrecoverable option on a archive loging enabled Database be
recorded in logs if we don't do a complete backup after
load ?

The changes will be logged, yes. And the table is fully available.
But until you take a backup (either online or offline) of at least
the tablespace, you won't be able to roll forward through the
load operation.

That's the point of NONRECOVERABLE: You're telling DB2 that you are
accepting that the tablespace will not be forward recoverable.

Aug 30 '07 #2