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.