To back up DB2 or DB2 DPF archive logs using the SBT interface, be sure to set the LOGARCHMETH1 parameter to "VENDOR", the LOGRETAIN parameter to "ON", the TRACKMOD parameter to "ON", and the USEREXIT parameter to "OFF" as discussed in Books Online.
Use this tab to administer online backups, offline backups and backup log files.
Online Backup
Specifies that backups for this subclient will be run with the database online. If a backup is run with the database online, other applications can access the database while the backup is in progress. Online backups are available only for databases configured with the logretain or userexit parameter enabled.
Offline Backup
Specifies that backups for this subclient will be run with the database offline. If a backup is run with the database offline, this job has an exclusive connection to the database; therefore, any other access to the database is not allowed while the backup is in progress. An offline backup cannot run if any other applications are already running on the database.
Number of Buffers
Use this space to specify the number of buffers for the backup. Default is 1. However, if you are backing up to multiple locations, you should use a sufficient number of buffers to improve performance, and to avoid potential backup failure.
Buffer Size
Use this space to specify the size (in 4 KB pages) of each buffer to be used for building the backup image. The minimum value is 8, and the default value is 1024. If you select value 0, the value of the backbufz database manager configuration parameter will be used as the buffer allocation size.
Back up Log Files
Specifies whether log files will be backed up for this subclient, and enables/disables the option to Delete Log Files After a backup. When cleared, you must select the Backup Data option on the Content tab.
|
|
In most cases,
to back up DB2 archive logs, be sure to set the
USEREXIT parameter to "ON".
For USEREXIT=OFF, you should back
up only either offline databases or online databases without the logs. You
cannot use the
USEREXIT parameter to back up DB2 DPF
archive logs. To back up DB2 or DB2 DPF archive logs using the SBT interface, be sure to set the LOGARCHMETH1 parameter to "VENDOR", the LOGRETAIN parameter to "ON", the TRACKMOD parameter to "ON", and the USEREXIT parameter to "OFF" as discussed in Books Online. |
Delete Log Files After
Specifies whether to delete the log files from the DB2 or DB2 DPF log path and the archive path after a backup but still keep the files in the backup media. This field is active only when the Back up Log Files option is selected.