Veritas NetBackup™ for DB2 Administrator's Guide

Last Published:
Product(s): NetBackup (9.0.0.1, 9.0)
  1. Introduction to NetBackup for DB2
    1.  
      Features of NetBackup for DB2
    2. NetBackup for DB2 overview
      1.  
        About the NetBackup for DB2 components
      2.  
        About NetBackup for DB2 terminology
  2. Installing NetBackup for DB2
    1.  
      Planning the installation of NetBackup for DB2
    2. Verifying the operating system and platform compatibility
      1.  
        NetBackup server and client requirements
      2.  
        DB2 server software requirements
      3.  
        Requirements for using NetBackup for SAP MaxDB, SAP Oracle, and SAP HANA in a NetBackup cluster
    3.  
      About the license for NetBackup for DB2
    4. About log archiving
      1.  
        Using the VENDOR archive method
      2.  
        Using the user exit archive method
    5.  
      Specifying the DB2 home path (UNIX)
    6.  
      About adding new DB2 instances
  3. Configuring NetBackup for DB2
    1.  
      Overview of NetBackup for DB2 configuration
    2.  
      About permissions for NetBackup for DB2 log files (UNIX)
    3. About configuring a backup policy for DB2
      1.  
        Adding a NetBackup for DB2 policy
      2.  
        About policy attributes
      3.  
        Adding clients to a policy
      4.  
        Specifying the master server for a NetBackup for DB2 client
      5.  
        Configuring a policy to back up the configuration files
      6.  
        Configuring the Maximum jobs per client
    4. About adding backup selections to a DB2 policy
      1.  
        About backup schedules, templates, and scripts
      2.  
        Adding a template to the backup selections list in the NetBackup Administration Console
      3.  
        Adding a script to the backup selections list in the NetBackup Administration Console
    5.  
      Configuring an application backup schedule
    6.  
      Example application backup schedule
    7.  
      Configuring automatic backup schedules
    8.  
      Example automatic backup schedule
    9.  
      About schedule properties
    10.  
      NetBackup for DB2 backup types
    11.  
      Performing a manual backup
    12.  
      Reviewing the auto-discovered mappings in Host Management
    13. About backing up archive log files with the user exit program
      1.  
        DB2 objects in the backup window
      2.  
        Configuring a policy to back up the archive logs
      3.  
        Configuring a policy to archive the archive logs
    14. Configuring the run-time environment
      1. Creating a db2.conf file for use with the user exit program
        1.  
          Example db2.conf file using ARCFUNC SAVE
        2.  
          Example db2.conf file using ARCFUNC COPY
      2. Creating a db2.conf file (vendor method)
        1.  
          Example db2.conf file (vendor method)
      3. Configuring bp.conf files in a cluster environment
        1.  
          Configuring a master bp.conf file
        2.  
          Configuring a user bp.conf file
      4.  
        Keywords for the db2.conf file
      5.  
        NetBackup for DB2 environment variables
      6.  
        Configuring the logon account for the NetBackup Client Service for NetBackup for DB2
    15. About NetBackup for DB2 templates and shell scripts
      1.  
        Specifying the NetBackup master server from the client
      2.  
        Creating a backup template using the NetBackup for DB2 backup wizard
      3.  
        Creating shell scripts using bpdbsbdb2
      4. Creating DB2 scripts manually
        1.  
          Modifying DB2 backup and install scripts
        2.  
          Script parameters
      5.  
        About NetBackup template and shell script storage
  4. Performing backups and restores of DB2
    1.  
      NetBackup for DB2 backup overview
    2.  
      About backups from the NetBackup master server
    3. About user-directed backups
      1.  
        Using the DB2 template administration interface to run a user-directed backup
      2.  
        Using bpdbsbdb2 to run a user-directed backup
      3.  
        Using DB2 to run a user-directed backup
      4.  
        BACKUP DATABASE command options
    4.  
      Using the Backup, Archive, and Restore interface to browse DB2 resources
    5.  
      About browsing DB2 backup images with bplist
    6. Performing a database restore
      1. Using the NetBackup for DB2 recovery wizard
        1.  
          Selecting files for restore
        2.  
          Using the recovery wizard
        3.  
          Using bpdbsbdb2 for a database restore
      2. Using DB2 to perform a restore
        1.  
          Recovering a DB2 database - Simplest case
        2.  
          Recovering a DB2 database - Restoring archive logs
        3.  
          RESTORE DATABASE command options
    7. About an alternate restore
      1.  
        Preparing the master server for an alternate restore
      2.  
        Performing the alternate restore on the clients
      3.  
        Restoring the transaction logs
  5. Using Snapshot Client with NetBackup for DB2
    1.  
      NetBackup for DB2 with Snapshot Client features
    2. About NetBackup for DB2 with Snapshot Client operations
      1.  
        About the sequence of a NetBackup for DB2 backup operation with Snapshot Client methods
      2.  
        About the sequence of a NetBackup for DB2 restore operation with Snapshot Client methods
      3.  
        About database objects supported by advanced backup methods
      4.  
        About multistreaming and DB2 snapshot backups
      5.  
        About symbolic links and DB2 backups and restores (UNIX)
      6.  
        NetBackup for DB2 stream-based operations
      7.  
        NetBackup for DB2 file-based operations
      8.  
        Example: multiple sessions for a DB2 snapshot backup
    3.  
      About configuring Snapshot Client with NetBackup for DB2
    4.  
      Configuration requirements for snapshot backups with NetBackup for DB2
    5.  
      Configuring a snapshot policy for NetBackup for DB2
    6.  
      About configuring the db2.conf for a snapshot policy
    7. Restoring NetBackup for DB2 from a snapshot backup
      1.  
        About restoring individual files from a NetBackup for DB2 snapshot backup
      2.  
        About NetBackup for DB2 restores of volumes and file systems using snapshot rollback
      3.  
        Performing a NetBackup for DB2 point-in-time rollback restore from a SnapVault backup (UNIX)
      4.  
        Performing a snapshot rollback restore from the Java or Windows interface
      5.  
        Performing a snapshot rollback restore from the command line
      6.  
        Troubleshooting NetBackup for DB2 rollback restores
    8. About configuring NetBackup for DB2 block-level incremental backups on UNIX
      1.  
        How BLI works with NetBackup for DB2 (UNIX)
      2.  
        About the Storage Checkpoint facility and NetBackup for DB2
      3.  
        Configuration requirements for BLI backups with NetBackup for DB2
      4.  
        Storage Checkpoint configuration on the NetBackup for DB2 client
      5. Configuring policies for BLI backups with NetBackup for DB2
        1.  
          About the types of NetBackup for DB2 BLI backups
      6.  
        BLI incremental backup options using NetBackup for DB2
    9. About Snapshot Client effects
      1.  
        How Snapshot Client software affects backup types
      2.  
        How Snapshot Client software affects schedule properties
      3.  
        How Snapshot Client software affects templates and scripts
    10.  
      Performing NetBackup for DB2 backups with Snapshot Client methods
    11.  
      Performing NetBackup for DB2 restores with Snapshot Client methods
  6. Troubleshooting NetBackup for DB2
    1.  
      NetBackup debug logs and reports
    2.  
      Enabling the debug logs for a NetBackup for DB2 client automatically (Windows)
    3.  
      Enabling the debug logs manually (Windows)
    4.  
      Enabling the debug logs manually (UNIX)
    5. About the NetBackup for DB2 log files
      1.  
        About the bphdb directory on the Windows database client
      2.  
        About the bphdb directory on the UNIX database client
      3.  
        About the bpdb2 directory on the UNIX database client
      4.  
        About the bpdbsbdb2 directory on the client
    6.  
      Setting the debug level on a Windows client
    7.  
      Setting the debug level on a UNIX client
    8.  
      About NetBackup server reports
    9.  
      Minimizing timeout failures on large database restores
    10.  
      Minimizing the loading and unloading of tapes for database backups
    11.  
      Use the NET_BUFFER_SZ file to speed up a slow restore
    12.  
      About false restore failures reported in the activity monitor
    13.  
      About the error message codes
    14.  
      Delays in completion of backup jobs
  7. Appendix A. Configuration for a DB2 EEE (DPF) environment
    1.  
      Overview of installation and configuration for a DB2 EEE (DPF) environment
    2.  
      Configuring NetBackup for DB2 in an EEE environment
    3.  
      Adding NetBackup policies for DB2 EEE environment
    4.  
      Backing up archive logs in a DB2 EEE environment
    5.  
      Creating DB2 templates or scripts for a DB2 EEE environment
  8. Appendix B. Using NetBackup for DB2 with SAP®
    1.  
      About NetBackup for DB2 with SAP
    2.  
      Installation of the DB2 user exit program
    3.  
      Backup and restore of DB2 databases used by SAP
    4.  
      Archive and restore of DB2 log files used by SAP
    5.  
      Backup of SAP files
  9. Appendix C. Register authorized locations
    1.  
      Registering authorized locations used by a NetBackup database script-based policy
  10.  
    Index

Performing the alternate restore on the clients

The following procedures explain how to restore a DB2 database and its transaction logs. The procedure builds a request to DB2 to find the backup images that correspond to the database you try to restore. Type the commands in this procedure from the client that receives the restored database.

To perform an alternate restore of a DB2 database

  1. Modify the db2.conf file on the destination client.

    Add the following definitions:

    • One to specify the alternate restore

    • One to define the new database

    • One to define the old database

    • One to define the new log files

    • One to define the old log files

    The following example shows the definition that is needed to specify the alternate restore:

    OBJECTTYPE ALTERNATE # Specifies an alternate restore
SRCINST db2v832d     # Names the source instance that was backed up
SRCALIAS SAMPLE      # Names the source database that was backed up
DESTINST db2v832t    # Names the destination instance name
DESTALIAS NEWSAMPL   # Names the destination database alias name
ENDOPER              # Ends the object definition

    The following example shows the definition that is needed to define the new database:

    DATABASE NEWSAMPL
OBJECTTYPE DATABASE
POLICY db2-bkup
SCHEDULE Default-Application-Backup
CLIENT_NAME Client1       # Restore to (and backup from) local host
ENDOPER

    The following example shows the definition that is needed to define the old database:

    DATABASE SAMPLE
OBJECTTYPE DATABASE
POLICY db2-bkup
SCHEDULE Default-Application-Backup
CLIENT_NAME Client2       # Restore from backup of remote host
ENDOPER

    The following example shows the definition that is needed to define the new archive log files:

    DATABASE NEWSAMPL
OBJECTTYPE ARCHIVE
POLICY db2_archive
SCHEDULE Default-Application-Backup
#SCHEDULE User            # Swap '#' on SCHEDULE for user-exit
CLIENT_NAME Client1       # Restore to (and backup from) local host
ARCFUNC SAVE 
ENDOPER

    The following example shows the definition that is needed to define the old archive log files:

    DATABASE SAMPLE
OBJECTTYPE ARCHIVE
POLICY db2_archive
SCHEDULE Default-Application-Backup
#SCHEDULE User            # Swap '#' on SCHEDULE for user-exit
CLIENT_NAME Client2       # Restore from backup of remote host
ARCFUNC SAVE
ENDOPER

  2. On the destination client, type the DB2 RESTORE command.

    Type this command in the following format:

    db2 restore db db_being_restored load lib_path into 
new_db_name redirect

    Where:

    db_being_restored

    Specify the name of the database that was backed up.

    lib_path

    Specify the full path to the NetBackup library.

    new_db_name

    Specify the name for the new database. If the name of the new database matches the name of a database presently included in the new instance, the new database overwrites the existing database.

    For example:

    Windows:

    db2 restore db sample load install_path\NetBackup\bin\nbdb2.dll 
   into newsampl redirect

    UNIX:

    db2 restore db sample load /usr/openv/netbackup/bin/nbdb2.sl 
   into newsampl redirect
  3. Set the location of the data files for the tablespace.

    Type this command in the following format:

    db2 set tablespace containers for 0 using "(path path)"

    Where path specifies the DB2 install path.

    For example, type one or more commands similar to the following:

    Windows:

    db2 set tablespace containers for 0 using "(path 
DB2_install_path\db2v832t\NODE0000\SQL00001\SQLT0000.0)"

    UNIX:

    db2 set tablespace containers for 0 using "(path 
DB2_install_path/db2v832t/NODE0000/SQL00001/SQLT0000.0)"
  4. Restore the database.

    Type the RESTORE command in the following format:

    db2 restore db db_being_restored continue

    For example:

    db2 restore db sample continue
  5. (Optional) Restore the transaction logs.

  6. Use the DB2 ROLLFORWARD command to restore the logs.

    Type this command in the following format:

    db2 rollforward db new_db_name to end of logs and stop

More Information

Restoring the transaction logs

About an alternate restore

Preparing the master server for an alternate restore

Restoring the transaction logs

Performing a database restore

NetBackup for DB2 backup overview