NetBackup™ for DB2 Administrator's Guide

Last Published:
Product(s): NetBackup & Alta Data Protection (10.5)
  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 DB2 in a NetBackup cluster
    3.  
      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.  
        Add clients to a policy
      4.  
        Specifying the primary 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 and scripts
      2.  
        Adding a script to the backup selections list
    5.  
      Configure an application backup schedule
    6.  
      Example application backup schedule
    7.  
      Configure automatic backup schedules
    8.  
      Example automatic backup schedule
    9.  
      Schedule properties
    10.  
      NetBackup for DB2 backup types
    11.  
      Perform a manual backup
    12.  
      Reviewing the auto-discovered mappings
    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 primary 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 shell scripts
      1. Creating DB2 scripts manually
        1.  
          Modifying DB2 backup and install scripts
        2.  
          Script parameters
      2.  
        About NetBackup shell script storage
    16.  
      RBAC role for the DB2 administrator
  4. Performing backups and restores of DB2
    1.  
      NetBackup for DB2 backup overview
    2.  
      About backups from the NetBackup primary server
    3. About user-directed backups
      1.  
        Using DB2 to run a user-directed backup
      2.  
        BACKUP DATABASE command options
    4.  
      About browsing DB2 backup images with bplist
    5. Performing a database restore
      1. Using DB2 to perform a restore
        1.  
          Restoring and recovering a DB2 database - with a catalog name that has been specified
        2.  
          Recovering a DB2 database - Simplest case
        3.  
          Recovering a DB2 database - Restoring archive logs
        4.  
          RESTORE DATABASE command options
    6. About an alternate restore
      1.  
        Preparing the primary server for an alternate restore
      2.  
        Performing the alternate restore on the clients
      3.  
        Restoring the transaction logs
    7.  
      About preventing the direct expiration of backup images
  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 command line
      5.  
        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 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) (NetBackup for DB2)
    4.  
      Enabling the debug logs manually (UNIX) (NetBackup for DB2)
    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
    6.  
      Setting the debug level on a Windows client
    7.  
    8.  
      Minimizing timeout failures on large database restores
    9.  
      Minimizing the loading and unloading of tapes for database backups
    10.  
      Use the NET_BUFFER_SZ file to speed up a slow restore
    11.  
      About false restore failures reported in the Activity monitor
    12.  
      About the error message codes
  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 the archive logs that are in a DB2 EEE environment
    5.  
      Creating DB2 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

NetBackup for DB2 backup overview

After you have completed installing and configuring NetBackup for DB2, you can start DB2 backups and restores through NetBackup. You can also run DB2 commands directly.

Note:

Always specify the correct DB2 script when you configure automatic backups or when operations start through NetBackup. NetBackup for DB2 does not generate an error if a restore DB2 script file is used for a backup operation. Also, NetBackup for DB2 does not generate an error when a backup DB2 script is used for a restore operation.

NetBackup for DB2 provides the following ways to perform a backup:

  • Issue a DB2 command from the DB2 control center or command-line processor. The DB2 BACKUP and RESTORE commands use the policies, schedules, and settings that are specified in the following sources:

    • The NetBackup for DB2 vendor I/O library.

      On UNIX, this library is named nbdb2.ext, where ext differs depending on your platform.

      On Windows, this library is named nbdb2.dll.

    • The NetBackup for DB2 configuration file. This file is named db2.conf.

  • Run a script from the operating system command line. You can create these scripts manually.

  • Use the scripts that are specified in policies. When you back up a NetBackup policy, it uses the scripts that are specified in the policy.

  • You can specify a catalog name during a database copy backup and an archive log backup.

The main types of DB2 backups are as follows:

database backup

database copy

A copy of the entire DB2 database or tablespace. This backup is accomplished by issuing a DB2 BACKUP DATABASE command. A database backup can be initiated through NetBackup by an automatic backup of a DB2 policy, manual backup of a DB2 policy, or user-directed backup.

You can specify the CATALOG_HOST in the db2.conf or the DB2_CATALOG_HOST in the VENDOROPT of the DB2 database configuration parameters or in the OPTIONS on the command line.

See About backups from the NetBackup primary server.

See About user-directed backups.

archive log backup

An archive log backup is a backup of an archive log file for DB2. If VENDOR is enabled in the DB2 configuration files, NetBackup for DB2 backs up the archive logs along with the database files. If the user exit program is enabled in the DB2 configuration file, you need a separate policy and schedule to back up the archive logs.

If you specify LOGARCHMETH1 and or LOGARCHMETH2 equal to VENDOR, you can specify the CATALOG_HOST in the db2.conf or specify the DB2_CATALOG_HOST in the LOGARCHOPT1 and or LOGARCHOPT2 respectively.

These CATALOG_HOST and DB2_CATALOG_HOST keywords do not apply to the archive log backups that use the user exit program.

configuration file backup

A configuration file backup is a backup of the DB2 configuration files that you need to recover the database in the case of a disaster.

You can use a Standard policy (UNIX) or MS-Windows policy with a User Backup schedule to back up the files.

For information on which files to back up, see your IBM DB2 documentation.