Restoring SAP DB2 data

Use the Data Protection for SAP file manager for managing restore operations.

Starting restores in a nonpartitioned database environment
The following examples show how you can start DB2® database/tablespace restores from the command line by using DB2® CLP.
Processing redirected restore in automatic mode
Backup Object Manager provides an automatic cloning function, which creates an exact copy of the original SAP database in a different location.
Understanding Tablespace definition information (TDI) reference
To automate a redirected restore operation, Backup Object Manager requires information about the table spaces and the table space containers that are used in the original database.
Processing redirected restore in batch mode
Backup Object Manager provides a redirected restore batch mode function where the TDI for the target database is modified before it starts the redirected restore.
Redirected restore in interactive mode
Backup Object Manager interactive mode is a menu-driven dialog where the table space container layout is redefined by adding, deleting, moving, or resizing items.
Sample work flow for redirected restore
A sample work flow for a redirected restore with Data Protection for SAP Backup Object Manager is given.
Redirected restore plausibility checks
Regardless of the mode of the redirected restore operation (automatic, interactive, batch), Backup Object Manager performs the following checks before the DB2® redirected restore operation begins.
DB2 redirected restore using Backup Object Manager
Backup Object Manager uses a simple set of commands to run a redirected restore of a database and also runs some plausibility checks before actually starting the operation.
Creating table space definition information
A table space definition image (TDI) is created after a full database backup completes successfully. It is stored on the IBM Storage Protect™ server with the database backup image. Only database backups for which a corresponding TDI is available can be used for redirected restore with Backup Object Manager.
Redirected restore prerequisites
The following requirements must be met for the Backup Object Manager to successfully run a redirected restore.
Tablespace definition information (Duplicate Needs RReview)
To perform a redirected restore, Backup Object Manager requires information about the physical layout of the original database, such as the tablespace containers used by the original database.

Parent topic: Protecting data