467,209 Members | 1,348 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

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


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
  • viewed: 1521
Share:
1 Reply
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.

Similar topics

3 posts views Thread by Kevin Thorpe | last post: by
7 posts views Thread by William | last post: by
2 posts views Thread by cogitoergosum | last post: by
3 posts views Thread by Jason Carlton | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.