Rollforward Overview

This utility recovers a database by applying transactions recorded in the database log files. It is invoked after a database or table space backup has been restored. The database must be recoverable before the database can be recovered with rollforward recovery.

In a multi-partitioned database environment, the rollforward database command can be issued only from the catalog partition.

					db2 rollforward db sample to end of logs
					                                       Rollforward Status
					Input database alias                   = sample
					Number of nodes have returned status   = 1
					Node number                            = 0
					Rollforward status                     = not pending
					Next log file to be read               =
					Log files processed                    = S0000000.LOG - S0000001.LOG
					Last committed transaction             = 2002-08-29-17.31.53.000000
					DB20000I The ROLLFORWARD command ...

Get Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial