Restore DB2 archive logs. When you restore the log files, the software restores the archive logs to the directories under the retrieve path. The logs remain in the folder until you manually remove the files.
Procedure
-
From the CommCell Browser, navigate to Client Computers > client > DB2 > DB2 instance.
-
Right-click the DB2 database backup set, point to All Tasks, and then click Browse and Restore.
The Browse and Restore dialog box is displayed.
-
On the Time Range tab, select Latest Backup and click View Content.
-
Select the databases to restore and click Recover All Selected.
The Restore Options dialog box appears.
-
Clear the Restore Data check box.
-
Click Advanced.
The Advanced Restore Options dialog box appears.
-
On the Roll-Forward tab, clear the Roll-forward (Reapply the Logs) check box.
-
On the Log Files tab, select the Restore Log Files check box.
-
On the Log Files tab, select the restore log option.
Restore all logs
Select the All Log Files option.
Restore logs to a point-in-time
Select By Point in Time and enter the Start and End time in the boxes.
Restore by specifying a serial number
You can get the LSNs that the software included in the backup from the Job Details dialog box. For information on how to view the job details, see Viewing Details of a Job.
Select the By Log Serial Number option.
Check the Start or End check boxes and enter the serial numbers.
The following are the rules for specifying the serial number.
-
The end serial number must be greater than or equal to the start serial number
-
The start and the end serial number cannot be 0
-
The range of serial numbers restore can be from one or more backup jobs or from a part of a job and from one or more cycles
-
When you specify only the start sequence number, logs starting from that sequence number to the current sequence number are restored
-
-
Click OK to close the Advanced Restore Options dialog box.
-
Click OK to close the Restore Options dialog box and start the restore.