Understanding DB2 and Data Protection for SAP configuration

Edit online

Data Protection for SAP data transfer functions are implemented in a shared library that is accessed by DB2®. When back up or restore operations are started, and log archive or log retrieve commands are entered, the shared library is accessed. This library requires information about the path of the Data Protection for SAP profile and the path of the log files that are written by Data Protection for SAP.

BACKUP DATABASE and RESTORE DATABASE

If an action is initiated by using the DB2 commands BACKUP DATABASE or RESTORE DATABASE, the information that is required must be specified in a vendor environment file. The name of the vendor environment file is sent to DB2 through either the OPTIONS parameter of the BACKUP DATABASE or RESTORE DATABASE commands. It can also be stored persistently in the database configuration parameter VENDOROPT. For log archive or log retrieve, this file can be stored either in the database configuration parameter LOGARCHOPT1 or in LOGARCHOPT2. For BACKUP DATABASE or RESTORE DATABASE, use of the OPTIONS keyword for this purpose is no longer necessary. It is advised that you keep the settings in the vendor environment file and in the system variables synchronized continually. For an example of a Data Protection for SAP vendor environment file, see Vendor environment file sample. If BACKUP DATABASE or RESTORE DATABASE is triggered through the backom utility, the information that is required must be specified in the environment.

Vendor environment file

Consider the following adjustment rules for Data Protection for SAP:
  • To select different Data Protection for SAP environment settings for a DB2 backup or restore, specify the full path of the vendor environment file in the OPTIONS parameter of the BACKUP DATABASE or RESTORE DATABASE commands. For details, refer to the DB2 Command Reference
  • To select a different Data Protection for SAP profile, modify the environment variable XINT_PROFILE to denote the new profile in the vendor environment file.
  • To select a different Data Protection for SAP profile for future calls to the backom utility, modify the environment variable XINT_PROFILE to denote the new profile.
  • To select a different Data Protection for SAP profile for a call to the backom utility, specify the path of the new profile in option e of the backom command.
  • To change the path for Data Protection for SAP process log files for a call to DB2 commands BACKUP DATABASE or RESTORE DATABASE, modify the environment variable TDP_DIR in the vendor environment file. Specify the file path in the OPTIONS parameter of the BACKUP DATABASE or RESTORE DATABASE commands.
  • To change the path for Data Protection for SAP process log files for future calls to the backom utility, modify the environment variable TDP_DIR to denote the new profile.