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

About the error message codes

The following table describes the DB2 and NetBackup reason codes. For more information about an error message, see the log files.

Errors can occur in the NetBackup shared library (UNIX) or DLL (Windows) if these are accessed during the processing of a DB2 database utility BACKUP or RESTORE.

Table: DB2 and NetBackup error codes

Error code

Description

300

Message: ERR - No match for a database image file was found based on the following criteria.

Cause: The restore criteria of database name, instance, type, and backup time object cannot be found in the NetBackup database.

Action: Use bplist to make sure that the image you want to restore exists. Make sure that the correct instance is used.

Make sure that the correct values are set in db2.conf. Also, on UNIX check the values in bp.conf.

If logging is enabled, check the current log file in the following directory for more information:

Windows: install_path\NetBackup\logs\bpdb2\

UNIX: /usr/openv/NetBackup/logs/bpdb2

305

Message: ERR - found more than one object.

Cause: Multiple DB2 backup images were found in the NetBackup database that matched the restore criteria of database name, instance, type, and backup time.

Action: This error should not occur under typical operations. If logging is enabled, check the current log file in the following directory for more information:

Windows: install_path\NetBackup\logs\bpdb2\

UNIX: /usr/openv/NetBackup/logs/bpdb2

310

Message: ERR - bp.config failed with status status.

Cause:

Windows: Unable to read configuration file.

UNIX: Unable to read configuration file /usr/openv/NetBackup/bp.conf

Action: Make sure that the file exists and is properly configured.

If logging is enabled, check the current log file in the following directory for more information:

Windows: install_path\NetBackup\logs\bpdb2\

UNIX: /usr/openv/NetBackup/logs/bpdb2

330

Message: ERR - Invalid options encountered for action action.

Cause: Invalid option(s) encountered for action.

Action: Make sure that the action parameters are used properly.

335

Message: ERR - in get DB2 UDB level.

Cause: NetBackup server and the NetBackup for DB2 shared library (UNIX) DB2 DLL (Windows) or are not at the same level.

Action: Make sure that the NetBackup and the NetBackup for DB2 shared library (UNIX) or the DB2 DLL (Windows) are at the same level. Check the log file in the following directory:

Windows: install_path\NetBackup\logs\

UNIX: /usr/openv/NetBackup/logs/bpdb2

Check the version number of the shared library and the version number for NetBackup. If they are not the same, install the same level.

380

Message: ERR - db2.conf read status error error.

Cause: db2.conf read status error.

Action: Make sure that the directory is accessible with read and write permissions. Make sure that the file exists and has read permission.

385

Message: ERR - Found multiple <DATABASE> entries before an <ENDOPER> entry was encountered.

Cause: Found multiple DATABASE entries before an ENDOPER entry was encountered in the following file:

Windows: install_path\NetBackup\dbext\db2.conf

UNIX: $HOME/db2.conf

Action: Remove the extra DATABASE entry.

390

Message: ERR - Found multiple <OBJECTTYPE> entries before an ENDOPER entry was encountered.

Cause: Found multiple OBJECTTYPE entries before an ENDOPER entry was encountered in the following file:

Windows: install_path\NetBackup\dbext\db2.conf

UNIX: $HOME/db2.conf

Action: Remove the extra OBJECTTYPE entry.

395

Message: ERR - Found multiple <POLICY> entries before an <ENDOPER> entries was encountered.

Cause: Found multiple POLICY entries before an ENDOPER entry was encountered in the following file:

Windows: install_path\NetBackup\dbext\db2.conf

UNIX: $HOME/db2.conf

Action: Remove the extra POLICY entry.

400

Message: ERR - Found multiple <SCHEDULE> entries before an <ENDOPER> entries was encountered.

Cause: Found multiple SCHEDULE entries before an ENDOPER entry was encountered in the following file:

Windows: install_path\NetBackup\dbext\db2.conf

UNIX: $HOME/db2.conf

Action: Remove the extra SCHEDULE entry.

405

Message: ERR - Found multiple <ARCFUNC> entries before an <ENDOPER> entries was encountered.

Cause: Found multiple ARCFUNC entries before an ENDOPER entry was encountered in the following file:

Windows: install_path\NetBackup\dbext\db2.conf

UNIX: $HOME/db2.conf

Action: Remove the extra ARCFUNC entry.

410

Message: ERR - Found multiple <ARCDIR> entries before an <ENDOPER> entries was encountered.

Cause: Found multiple ARCDIR entries before an ENDOPER entry was encountered in the following file:

Windows: install_path\NetBackup\dbext\db2.conf

UNIX: $HOME/db2.conf

Action: Remove the extra ARCDIR entry.

415

Message: ERR - Found multiple <RETDIR> entries before an <ENDOPER> entries was encountered.

Cause: Found multiple RETDIR entries before an ENDOPER entry was encountered in the following file:

Windows: install_path\NetBackup\dbext\db2.conf

UNIX: $HOME/db2.conf

Action: Remove the extra RETDIR entry.

420

Message: ERR - need to specify a valid POLICY or SCHEDULE in db2.conf for <DATABASE database> and <OBJECTTYPE objecttype>.

Cause: Policy name or schedule name is not specified in the POLICY or SCHEDULE entry in the following file:

Windows: install_path\NetBackup\dbext\db2.conf

UNIX: $HOME/db2.conf

Action: Add an appropriate policy name or schedule name to the POLICY or SCHEDULE entry.

425

Message: ERR - need to specify a valid ARCDIR in db2.conf: Errno =error_no : string.

Cause: Invalid ARCDIR is specified in db2.conf.

Action: Add an appropriate directory name to the ARCDIR entry.

430

Message: ERR - ARCDIR field needs to be specified in the db2.conf file.

Cause: No ARCDIR entry is found in the following file:

Windows: install_path\NetBackup\dbext\db2.conf

UNIX: $HOME/db2.conf

Action: Add an ARCDIR field with an appropriate directory name to the following file:

435

Message: ERR - RETDIR field needs to contain a valid file when OBJECTTYPE is equal to ARCHIVE: string.

Cause: RETDIR field does not contain a valid file.

Action: RETDIR field must contain a valid file when OBJECTTYPE ARCHIVE is specified in the following file:

Windows: install_path\NetBackup\dbext\db2.conf

UNIX: $HOME/db2.conf

440

Message: ERR - COPY or SAVE needs to be specified for ARCFUNC when OBJECTTYPE is equal to ARCHIVE.

Cause: Found OBJECTTYPE ARCHIVE but no ARCFUNC in the db2.conf file.

Action: Specify a copy or save parameter for ARCFUNC if OBJECTTYPE ARCHIVE is also specified.

445

Message: ERR - Invalid <OBJECTTYPE> entries: entry.

Cause: Invalid OBJECTTYPE entry in the following file:

Windows: install_path\NetBackup\dbext\db2.conf

UNIX: $HOME/db2.conf

Action: Add the appropriate object type.

450

Message: ERR - OBJECTTYPE entry needs to be specified.

Cause: OBJECTTYPE entry is not specified in the following file:

Windows: install_path\NetBackup\dbext\db2.conf

UNIX: $HOME/db2.conf

Action: Add the appropriate object type.

455

Message: ERR - POLICY entry needs to be specified.

Cause: POLICY entry is not specified in the following file:

Windows: install_path\NetBackup\dbext\db2.conf

UNIX: $HOME/db2.conf

Action: Add the appropriate policy name.

502

Message: NetBackup DB2 Handle Invalid

Cause: Internal communication between DB2 and NetBackup failed.

505

Message: The input parameters supplied by DB2 are not valid.

Cause: This error can occur when you use an unsupported version of DB2.

507

Message: NetBackup Initialize Failed

Cause: NetBackup encountered errors in preparing for the requested operation. This error can result from improper configuration.

510

Message: NetBackup Read Config Failed

Cause: NetBackup encountered errors in reading configuration settings.

Action: Check that the NetBackup client and server settings are configured. Also verify that the db2.conf file exists and that it is configured.

511

Message: NetBackup Write Config Failed

Cause: NetBackup encountered errors in preparing for the requested operation. This error can result from improper configuration.

513

Message: NetBackup Begin Action Failed

Cause: NetBackup encountered errors attempting to start the requested operation. This error can indicate a problem in obtaining necessary resources.

514

Message: NetBackup Create Image Failed

Cause: NetBackup encountered errors attempting to create a backup image.

515

Message: NetBackup Get Image Failed

Cause: NetBackup encountered errors attempting to access a backup image.

516

Message: NetBackup Find Image Failed

Cause: NetBackup encountered errors attempting to locate a backup image.

518

Message: NetBackup Write Failed

Cause: NetBackup encountered errors writing a backup image.

520

Message: NetBackup Read Failed

Cause: NetBackup encountered errors reading a backup image.

523

Message: NetBackup Commit Data Failed

Cause: NetBackup encountered errors attempting to close the backup image.

524

Message: NetBackup Commit Action Failed

Cause: NetBackup encountered errors attempting to complete the requested operation.

526

Message: NetBackup Abort Action Failed

Cause: NetBackup encountered errors attempting to abort the previously requested operation.

528

Message: NetBackup Delete Image Failed

Cause: NetBackup encountered errors attempting to expire an incomplete backup image. This error typically indicates that the previous operation has failed, and DB2 tried to delete any incomplete images.