IBM Books

Roll-Forward Database Overview

Use the roll-forward notebook to apply the changes that are recorded in the logs for a selected database or database partition. Before you can perform roll-forward recovery, the database object must be in the roll-forward pending state, and you must have the logs.

Graphic denoting single-partition database environments appears here. In a single-partition database environment, you can perform the roll-forward operation on a database, table space, or group of table spaces.

Graphic denoting partitioned database environments appears here. In a partitioned database environment, you can perform the roll-forward operation on a database partition, table space partition, or group of table space partitions. The following considerations apply to the partitioned database environment:

Notes:

  1. Graphic denoting partitioned database environments appears here. In a partitioned database environment, the database is located across many database server partitions. In this environment, if you are performing point-in-time roll-forward recovery, all database partitions must be rolled forward to ensure that all partitions are at the same level. If you need to restore a single database partition, you can perform roll-forward recovery to the end of the logs to bring it up to the same level as the other database partitions in the database.

  2. Graphic denoting partitioned database environments appears here. If, in the partitioned database environment, some database partitions are in the roll-forward pending state, and, on other nodes, some table spaces are in the roll-forward pending state, you must first roll forward the database partitions, then roll forward the table spaces.

Figure rule not displayed.

Tasks


Figure rule not displayed.

Page Controls


Figure rule not displayed.

Controls


Figure rule not displayed.

Related information

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

[ DB2 List of Books | Search the DB2 Books ]