Veritas NetBackup™ for DB2 Administrator's Guide
- Introduction to NetBackup for DB2
- Installing NetBackup for DB2
- Verifying the operating system and platform compatibility
- About log archiving
- Configuring NetBackup for DB2
- About configuring a backup policy for DB2
- About adding backup selections to a DB2 policy
- About backing up archive log files with the user exit program
- Configuring the run-time environment
- Creating a db2.conf file for use with the user exit program
- Creating a db2.conf file (vendor method)
- Configuring bp.conf files in a cluster environment
- About NetBackup for DB2 templates and shell scripts
- Creating DB2 scripts manually
- Performing backups and restores of DB2
- About user-directed backups
- Performing a database restore
- About an alternate restore
- Using Snapshot Client with NetBackup for DB2
- About NetBackup for DB2 with Snapshot Client operations
- Restoring NetBackup for DB2 from a snapshot backup
- About configuring NetBackup for DB2 block-level incremental backups on UNIX
- Configuring policies for BLI backups with NetBackup for DB2
- About Snapshot Client effects
- Troubleshooting NetBackup for DB2
- About the NetBackup for DB2 log files
- Appendix A. Configuration for a DB2 EEE (DPF) environment
- Appendix B. Using NetBackup for DB2 with SAP®
- Appendix C. Register authorized locations
Performing a snapshot rollback restore from the Java or Windows interface
This topic describes how to perform a snapshot rollback restore from the Java or Windows interface.
To perform a snapshot rollback restore from the Java or Windows interface
- If the file .SQLCRT.FLG exists, delete it.
DB2 creates the .SQLCRT.FLG file when it creates a directory (usually during tablespace creation). For volume level rollback restores this file cannot be present. The directory structure must be present at the time DB2 creates a tablespace. Or you must delete this file after DB2 creates the directory during tablespace creation.
- Open the Backup, Archive, and Restore interface.
- Select one of the following:
In the Java interface, click the Restore Files tab.
In the Windows interface, select File > Select Files and Folders to Restore.
- Select Actions > Select Restore Type > Point in Time Rollback.
- Use the NetBackup for DB2 recovery wizard for the restore.