Performing a DB2 Log Backup

Use log backups in the following scenarios.

• To restore the database to the most recent state after a database failure.

• To restore specific logs, which are identified using a serial number or identification tag that are missing in the database.

• To restore logs from a specific time range that were lost due to a hard disk corruption. Use a point-in-time archive log restore.

You can also configure an archive log subclient, or include the archive logs as part of an offline subclient.

Before You Begin

Create a log subclient.

Procedure

1. From the CommCell Browser, expand Client Computers > client> DB2 >instance > backup_set.

2. Right-click the subclient and click Backup.

3. On the Backup Options for Subclient dialog box, select the backup type and job initiation:

   1. In the Backup Type section, select the Full option.

   2. In the Job Initiation section, specify whether to run the backup now or if it will be scheduled.

      Note

      If you selected Schedule, set up the schedule.

      For information about configuring a backup schedule, see Schedule Backups.

4. Click OK to close the Backup Options dialog box.

Result

The Job Details dialog box displays the following information:

• The completion time. Use this when you want to perform a point-in-time restore.

• The Log Serial Number (LSN) range. Use this when you want to restore a set of log files.

For information on how to view the job details, see Viewing Details of a Job.

Related Topics