Restore commands

Edit online

Use the restore commands to restore any backup object that was created by Data Protection for DB2®.

  • Restore the database with these command options:backom -c r_db -a database alias [-n node number] [-u userid][-p password] [-t timestamp] [-b buffer size] [-B number of buffers] [-S sessions] [-P parallelism] [-R restore type] [-O][-e execution profile] [-x] [-v]
  • Restore the database with these command options to a different location (redirected restore) in automatic mode: backom -c rr_db_clone -a original database alias,target database alias [-i instance] [-n node number] [-u userid] [-p password][-t timestamp] [-b buffer size] [-B number of buffers] [-S sessions] [-P parallelism][-D target database directory][-e execution profile] [-s scaling factor] [-N] [-C] [-v]
  • Restore the database with these command options to a different location (redirected restore) in batch mode:backom -c rr_db_batch -a original database alias,target database alias -f TDI image [-i instance] [-n node number] [-u userid][-p password] [-t timestamp][-b buffer size][-B number of buffers] [-S sessions] [-P parallelism][-D target database directory][-e execution profile][-s scaling factor] [-N][-C] [-v]
  • Restore the database with these command options to a different location (redirected restore) in interactive mode:backom -c rr_db_interactive -a original database alias,target database alias [-i instance] [-n node number] [-u userid] [-p password ][-t timestamp] [-f modified TDI image] [-b buffer size][-B number of buffers] [-S sessions][-P parallelism][-D target database] [-e execution profile] [-s scaling factor][-N][-C] [-v]
  • Restore the table spaces with these command options: backom -c r_ts -a database alias [-n node number] [-u userid][-p password] [ -t timestamp] [-b buffer size] [-B number of buffers] [-S sessions] [-P parallelism] [-R restore type ] [-O][-e execution profile] [-x] [-v]
  • Restore the DB2 Recovery History File of the database with these command options: backom -c r_hfile -a database alias [-n node number][-t timestamp] [-u userid] [-p password] [-b buffer size][-B number of buffers] [-S sessions] [-P parallelism][-e execution profile] [-x] [-v]
  • Restore the table space definition information (TDI) denoted by the command options: backom -c r_tdi -t timestamp -a database alias [-d destination directory] [-e execution profile] [-x] [-v]
  • Retrieve the DB2 log files with these command options: backom -c r_log -a database alias -l log number|log number range -d destination directory [-n node number] [-t timestamp|time range] [-e execution profile] [-x] [-v]
  • Retrieve the file or files that are specified by the -f command option to the path specified by command option -d:backom -c r_raw -f file name-d destination directory [-e execution profile] [-x] [-v] This command can restore data to the destination directory. If a single segment was used during the backup, the data can be restored to DB2 from the destination directory after retrieval. If two or more segments were used during the backup, the data can be restored to the destination directory but cannot be restored to DB2.