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
Ian - 30 Aug 2007 23:45 GMT
> 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.