When you use the Agent for DB2 to create a restore job, you can select specific restore options.
See Restoring DB2 data.
The following table describes the restore options available for DB2.
Table: DB2 restore options
|
Item
|
Description
|
|
Restore database from full and/or incremental backups |
Enables restore options.
|
|
To the most recent available |
Restores the DB2 database to the most recent full and incremental backups that are available.
|
|
To a point in time |
Restores data up to and including a point in time that is in the job log. After the point in time, recovery stops.
In the Date box, select the part of the date that you want to change, and then enter a new date or click the arrow to display a calendar from which you can select a date.
In the Time box, select the part of the time that you want to change, and then enter a new time or click the arrows to select a new time.
|
|
Roll forward using logs |
Enables a restore of a database that has archive logging enabled. To restore a database completely, you must also check Restore from full and/or incremental backups.
You can restore the database, and then perform the roll forward operation later.
For databases that have circular logging enabled, you must uncheck Roll forward using logs or the job will fail.
|
|
To the most recent available |
Rolls the DB2 database forward to the most recent logs that are available.
|
|
To a point in time |
Restores logs up to and including a point in time. After the point in time, recovery stops.
In the Date box, select the part of the date that you want to change, and then enter a new date or click the arrow to display a calendar from which you can select a date.
In the Time box, select the part of the time that you want to change, and then enter a new time or click the arrows to select a new time.
|
|
Override default log file path on DB2 server for this job |
Specifies an alternate log file path location to search for archive log files during the roll forward operation. You should specify an alternate location if archive log files were moved to a location other than the location that was specified by the logpath database configuration on the destination DB2 server. Type the full path for the archive logs location.
Selecting this option does not change the archive log path configuration on the DB2 server.
|
|
Bring database online when finished rolling forward |
Ensures that the database is brought online as soon as the recovery is finished.
|
DB2 restore options