Use this tab to administer log file restores.
Restore Log Files
Specifies that you can enable log file restores.
Note
Beginning in Service Pack 12, this option is no longer the default option.
-
All Log Files
Specifies whether to restore all log files.
-
By Point in Time
Depending on the corresponding selected Start and End options, specifies whether to restore log files based on a start time and an end time. To change the start and end dates, click in the lists as appropriate. Also, use the spaces to set the appropriate start and end times.
-
By Log Serial Number
Depending on the corresponding selected Start and End options, specifies whether to restore log files by log sequence number. Use the spaces to set the start and end log sequence numbers.
Restore Logs from Backup Image (use Logtarget)
You can use this option when you do not select the Recover Database option (Restore Options dialog box, Recover tab, clear the Recover DB check box).
This option extracts the files from the backup image to the DB2 Retrieve Path that you can specify during installation or by using an additional setting. The software extracts the files to:
UNIX
<DB2_Retrieve_Path>/<db2_instance_name/<db2_database_name>/LogsFromBackupImage/
Windows
<DB2_Retrieve_Path>\<db2_instance_name\<db2_database_name>\LogsFromBackupImage\