Specifying the VENDOROPT parameter

Edit online

You can select a default set of Data Protection for SAP for DB2® environment settings for commands BACKUP DATABASE, RESTORE DATABASE, and for the DB2 Log Manager.

About this task

This command can be used as an alternative to the db2set command and provides these advantages:
  • You do not need to restart the DB2 instance.
  • You can define default values for the OPTIONS parameter of the BACKUP DATABASE command in the DB2 configuration.
  • You can define default values for the OPTIONS parameter of the RESTORE DATABASE command in the DB2 configuration.
  • The same settings can be applied to database backup and restore, and to log file archive and retrieve options.
When you use the BACKUP DATABASE and RESTORE DATABASE commands with the USE SNAPSHOT option for snapshot-based backup and restore by DB2 ACS or FlashCopy® Manager, the VENDOROPT parameter is ignored. In this case, any options other than the default values must be set by using the OPTIONS keyword.

Procedure

  1. Modify the DB2 database configuration to denote a file that contains the following settings:
    db2 update db cfg for SID using LOGARCHOPT1|2 vendor environment file, where vendor environment file is the fully qualified path of the file that contains Data Protection for SAP environment settings for DB2.
  2. Verify that the environment settings of your system match the settings in this file.