By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,017 Members | 979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,017 IT Pros & Developers. It's quick & easy.

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

P: n/a

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
Share this Question
Share on Google+
1 Reply


P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.