For the complete documentation index, see llms.txt. This page is also available as Markdown.

DB2

To create a new application for DB2 database backup, go to the tab: Applications -> Instances

Then select the Create button. The Creating an Application Definition section will be displayed, which needs to be completed.

This is a description of how your script is going to be invoked - you need to specify:

  • Name - unique name of the application in the Storware Backup & Recovery system.

  • Choose Node Config - select which node should perform the task.

  • Backup policy - specify which backup policy should be used for this application.

  • Command execution configuration - select a prepared template for DB2 backup or create a new one yourself.

In the SSH access subtab, complete the following fields:

  • Host - set the address of the host where the DB2 instance exists.

  • Port - set the host port.

Next, select OS Credentials or create a new one and provide the following information:

  • Name - unique name of the OS Credentials.

  • User - indicate a user for SSH connection.

  • Password - enter the connection password.

  • SSH key path - alternatively, you can specify the SSH key path for authorization.

After saving the application configuration, define the following environment variables:

Environment Variables

Variable
Value
Description

VP_DB2_INCREMENTAL

yes / no

Creates an incremental backup on the DB2 server. Set to no for a full backup.

VP_DB2_DBLIST

string

Database names to back up. Separate multiple names with commas.

VP_DB2_SCRIPTPATH

string

Path to the backup script on the DB2 host. Copy the appropriate script from /opt/vprotect/server/scripts/application to the database host. Then specify its destination path here.

VP_DB2_PASSWORD

string

Password for the DB2 database user.

VP_DB2_COMPRESS

yes / no

Compresses the backup on the DB2 server.

VP_DB2_LOGFILE

string

Path on the DB2 server for the backup job log file.

VP_DB2_USER

string

DB2 login username.

VP_DB2_STOREPATH

string

Path on the DB2 server for the backup file.

Note: After the new application is fully configured, save the changes and go to the Backup SLAs configuration.