IBM Books

Perform nonrecoverable load operation

Select this check box to specify this load as a nonrecoverable load.

By default, if forward recovery is enabled for the database in which this table resides and you load data into the table, the table spaces for that table are placed in backup pending state. In this case, the data in the table is not accessible until a table space backup or a full database backup is made.

If you don't want the table spaces to be placed in backup pending state, you can either perform a nonrecoverable load by specifying this check box, or create an image copy of the loaded data by selecting the Save a copy of the changes made check box. Selecting the Perform nonrecoverable load operation check box allows you to perform the load without jeopardizing the recoverability of all the other tables in the database and without the overhead of building a copy of all of the changes made.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]