Get Backup Time Stamp

To restore IBM Db2 databases from a backup, you need a backup time stamp. IBM Db2 generates a time stamp for each backup in the yyyymmddhhmmss format. Using this timestamp, Veeam Plug-in restores the database from the backup file created at the certain time.

To get backup details, run the -get-restore-points command:

/opt/veeam/VeeamPluginforDB2/DB2ConfigTool --get-restore-points --time-range <time_period> database <database_name> --json > <timestamps.json>

where:

  • <time_period> is a time period when the backup you need was created. You must specify this value in a time stamp format. For details, see Command Parameters.
  • <database_name> is a name of a database whose backups you need.
  • <timestamps.json> is a name of a .JSON file with the command output.

If the command run is successful, Veeam Plug-in provides the following details of your machine backups that are available in the connected backup repository:

  • Database instance name
  • Database name
  • Partition number
  • Time stamp
  • Backup type. Possible values:
  • Full
  • Incremental
  • Delta

Command Parameters

You can specify the following parameters for the --get-restore-points command:

Parameter

Description

--help

Shows the list of parameters for the --get-restore-points command.

--time-range

Defines the time period when the backup was created. Veeam Plug-in will return the list of backups created within the specified period.

Using the --time-range parameter, you can select the level of details for a time stamp from yyyymm to yyyymmddhhmmss. For example, if you use following time stamp, Veeam Plug-in will return the list of backups created within a certain hour: 2024052417.

--database

This parameter is optional. Defines the name of the backed-up database. Veeam Plug-in will return the list of backups only of the specified database.

--json

This parameter is optional. If you use this parameter, Veeam Plug-in create a .JSON file in your current directory and collect the command output in this file.