Veritas NetBackup™ for DB2 Administrator's Guide

Last Published:
Product(s): NetBackup (9.1)
  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.  
          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
    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

Keywords for the db2.conf file

The db2.conf file provides definitions NetBackup uses to perform DB2 backup and restore operations.

  • Each definition is a grouping of keyword value pairs.

  • Each definition contains an OBJECTTYPE keyword and value.

  • Each definition ends with the ENDOPER keyword.

  • All other keyword value pairs are optional, depending on the OBJECTTYPE.

  • Within a definition, the keyword value pairs can appear in any order.

  • The keywords are not case-sensitive, but the values are case-sensitive.

  • When a pound character (#) appears in the first column, the line is treated as a comment.

  • Backup and restore operations have two definitions, one for OBJECTTYPE DATABASE or TABLESPACE and one for OBJECTTYPE ARCHIVE.

  • Restore operations to a different instance or database (not the original) must also have a definition for OBJECTTYPE ALTERNATE.

  • NetBackup searches the file from top to bottom and uses the first definition that is found for the operation being performed. Later definitions for the same operation are ignored.

  • NetBackup searches each definition from top to bottom and uses the first value specified for each keyword found. Later definitions for the same keyword are ignored.

The db2.conf file specifies the keywords that are described in this topic. If LOGARCHMETH1 VENDOR is configured in your DB2 environment, NetBackup for DB2 ignores the following keywords.

The following keywords:

  • ARCDIR

  • ARCFUNC SAVE

  • ARCFUNC COPY

  • PARTITIONTYPE RAW

  • RETDIR

Table: Keyword value pairs for the db2.conf file describes the keywords and values that are used.

Table: Keyword value pairs for the db2.conf file

Keyword value

Description

ARCDIR dir
						

Full path to the location of the archive logs. No default.

Required if ARCFUNC COPY is also specified.

Note:

Ignored for LOGARCHMETH1 VENDOR.

ARCFUNC SAVE
ARCFUNC COPY

ARCFUNC SAVE saves archive logs to/from NetBackup.

ARCFUNC COPY copies archive logs to/from ARCDIR/RETDIR directories.

You must specify either ARCFUNC SAVE or ARCFUNC COPY if OBJECTTYPE ARCHIVE is also specified.

Note:

Ignored for LOGARCHMETH1 VENDOR.

CATALOG_HOST

The catalog name under which backup images are cataloged.

For UNIX: BKUP_IMAGE_PERM

Lets you set the permissions on a backup image at backup time. Possible values are the following:

  • USER - set the permissions to 600. Only the original user who backed up the data has access to the backup images.

  • GROUP - set the permissions to 660. Anyone from the same group as the original user who backed up the data has access to the backup images.

  • ANY - set the permissions to 664. Anyone has access to the backup images.

If this variable is not specified, the permissions default to 660.

Does not apply to backups by the user exit program, normal file system permissions are used. If you use LOGARCHMETH1 VENDOR, you can use the new keyword in the db2.conf or specify the keyword in the LOGARCHOPT1 parameter in the database configuration.

CLIENT_NAMEclient_name

An alternate client name. Most commonly used to specify a different source client to use for alternate restores. May also be used on multi-homed client hosts to specify a host name that is associated with a specific local network interface. This host name can be different from the host name that is used for file system backups.

DATABASE db_name

DB2 database name. No default. Required for all definitions except OBJECTTYPE ALTERNATE.

DB2_COPY_NUMBER

Allows the user to explicitly specify the copy number to be used to perform restores.

DB2_MEDIA_SERVER

Allows the user to explicitly specify the media server to be used to perform restores. The media server must have access to the copy of the image from which the restore occurs.

DESTALIAS db_name
DESTINST inst_name
						

DESTALIAS specifies the database alias name of the destination database for an alternate restore.

DESTINST specifies the instance name of the destination instance for an alternate restore.

No default. Required for OBJECTTYPE ALTERNATE.

ENDOPER

Signals the end of a definition. Required at the end of each definition.

FORCE_BACKUP_CLIENT

The local client name. The client name is needed when DB2 performs an archive backup immediately following an alternate restore from another client. This client name allows the backup to be taken using the correct client name for the local host. The CLIENT_NAME still references the source client that is used to select the backup images that the restore needs.

NODE number

Specifies the DB2 node number that must match the local node in order for the other keywords and values to be used. Do not specify this keyword unless you operate within a DB2 Enterprise Extended Edition (EEE) environment. Not required. No default.

OBJECTTYPE ALTERNATE
OBJECTTYPE ARCHIVE
OBJECTTYPE DATABASE
OBJECTTYPE TABLESPACE

Specify OBJECTTYPE ALTERNATE to indicate that the definition pertains to performing a restore from an alternate instance or alternate database.

Specify OBJECTTYPE DATABASE or OBJECTTYPE TABLESPACE for database container backup or restore. Specify OBJECTTYPE ARCHIVE for archive log backup or restore.

One of OBJECTTYPE ALTERNATE, OBJECTTYPE ARCHIVE, OBJECTTYPE DATABASE, or OBJECTTYPE TABLESPACE is required in all db2.conf files. OBJECTTYPE ALTERNATE is required only if you want to perform an alternate restore.

PARTITIONTYPE RAW

Specifies that NetBackup search for archive log files that are backed up from a raw partition during a restore. Not Required. For the POLICY, specify the name of a DB2 policy. This policy can be the same as the one that you use to back up the database. In the SCHEDULE line, specify an Application Backup schedule.

POLICY pol_name

The name of a NetBackup policy. If not specified, NetBackup uses the first policy of the correct type that is found in the configuration on the NetBackup master server.

The policy should be of type DB2 unless the definition is OBJECTTYPE ARCHIVE for use with the user exit program and ARCFUNC SAVE. In that case it should be of type MS-Windows or Standard.

Does not apply to OBJECTTYPE ALTERNATE. Should be specified for all other definitions.

RESTORE_PRIORITY

Specifies the restore priority in NetBackup.

RETDIR dir

Full path to the location from which the archive logs are retrieved. No default.

Required if ARCFUNC COPY is also specified.

SCHEDULE sched_name

NetBackup schedule name in the policy. The default is the first schedule of the correct type in the policy.

The schedule should be of type Application Backup unless the definition is OBJECTTYPE ARCHIVE for use with the user exit program and ARCFUNC SAVE. In that case it should be of type User Backup.

Does not apply to OBJECTTYPE ALTERNATE.

SERVER

Name of the NetBackup master server.

SRCALIAS src_db_name
SRCINST src_inst_name
						

SRCALIAS specifies the database alias name of the source database for an alternate restore.

SRCINST specifies the instance name of the source instance for an alternate restore.

No defaults. Required for OBJECTTYPE ALTERNATE.