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
BACKUP DATABASE command options
You can back up a DB2 database to NetBackup with either the DB2 BACKUP DATABASE command or with its alternative syntax, BACKUP DB.
Table: DB2 BACKUP command options lists the command options when used in a NetBackup for DB2 environment.
Table: DB2 BACKUP command options
Instructs DB2 to use the NBDB2 vendor library when it performs the backup.
OPEN number SESSIONS
Specifies the number of concurrent data streams used for writing data. Use this option if you have multiple backup devices available, or you have multiplexing enabled in NetBackup.
WITH number BUFFERS
Use this option when opening multiple sessions. See OPEN number SESSIONS. The number of buffers must be twice the number of sessions.
Use this option to increase or decrease the buffer size, if necessary. Increased size can benefit performance, but decreased size might be necessary if using numerous buffers. DB2 recommends that the size be a multiple of the extent size. The DB2 DFT_EXTENT_SZ setting defines the default extent size.
This option is required for unattended backups. It must be specified in the backup scripts that NetBackup executes.
Use this option to perform a cumulative backup.
Use this option to perform a differential backup.
Use this option to back up hot, or active, databases.
Specifies the options that are to be used for the backup operation. The string passes to the vendor support library, for example
When the options DB2_POLICY, DB2_SCHED, DB2_SERVER, DB2_CLIENT, or BKUP_IMAGE_PERM are specified, the corresponding environment variables and
For more details about these options:
If multiple key=value pairs are specified, they are colon delimited. The following example shows colon delimited key=value pairs:
DB2 BACKUP ... OPTIONS "DB2_POLICY=policy3:DB2_SCHED=sched4"
Specifying this option overrides the value that the VENDOROPT database configuration parameter specifies.
Determines the number of tablespaces which can be read in parallel by the backup utility. DB2 automatically chooses an optimal value for this parameter unless you explicitly enter a value.