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.