To restore DB2 data

1. On the navigation bar, click the arrow next to Restore.

2. Click New Restore Job.

3. On the Properties pane, under Source, click Selections.

4. Click the View by Resource tab.

5. Expand the All Resources icon.

6. Expand the system resource that contains the database instance that you want to restore.

7. Do one of the following:

   To restore the entire database	Check Current Database. If the database is offline, the Current Database is empty and you cannot make selections.
   To restore a backup set	Check a backup set, or a historical set.
   To restore a table space	Expand either Current Database or a backup set, and then check any of the table spaces that you want to restore.

8. On the properties pane, under Settings, click DB2.

9. Complete the appropriate options as follows.

   Restore database from full and/or incremental backups	Check Restore database from full and/or incremental backups to enable restore options.
   To the most recent available	Select this option to restore the DB2 database to the most recent full and incremental backups that are available.
   To a point in time	Select this option to restore 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	Check Roll forward using logs to enable 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	Select this option to roll the DB2 database forward to the most recent logs that are available.
   To a point in time	Select this option to restore 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	Specify 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	Check Bring database online when finished rolling forward to ensure that the database is brought online as soon as the recovery is finished.

10. Select other restore options from the Properties pane as appropriate, and then start the restore job.

    See Restoring data by setting job properties.

11. Run a full backup of the restored database.