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.

About this task

The Backup Object Manager must be used to create a TDI for an offline database backup image. For example, this command starts an offline database backup by using two sessions:
backom -c b_db -a database alias -S 2
A TDI is not created when you use the DB2® command-line interface to run an offline database backup.
There are two methods available to create a TDI for an online database backup image:
  • One method is to use the Backup Object Manager backup function. For example, this command starts an online database backup by using two sessions:
    backom -c b_db -a database alias -S 2 -O 
  • Another method is to use the DB2 command-line interface to start an online backup with the BACKOM_LOCATION parameter set in the vendor environment file. When the value of this parameter specifies the backom executable file, the TDI is stored on the IBM Storage Protect server after the backup completes successfully. This statement must be included in the DB2 vendor environment file:
    BACKOM_LOCATION=fully qualified path and name of the backom executable
    The DB2 backup command can then be entered on the DB2 command-line interface:
    db2 backup db database alias online load shared library open 2 sessions 
Use the Backup Object Manager query function to verify whether a TDI image is available for a Data Protection for SAP backup image.