DB2 Command Line Example: Performing an In-place Restore

You can use a full, incremental or differential backup to perform an in-place restore.

Procedure

• At the DB2 command prompt, type the following command, substituting the database_parameter database_name with your database name and the backup_image_timestamp with the backup image timestamp:

  Note

  For a DB2 instance on 64-bit AIX, Solaris, HP PARISC or 64-bit Linux on System Z, replace Base with Base64.

  The backup image timestamp is 14 characters. It has the following format:

  yyyymmddhhmmss

  • yyyy - the year

  • mm - the 2 digit month representation (01-12)

  • dd - the day

  • hh - the hour in 24-hour clock format (00-23)

  • mm - the minute (0-59)

  • ss - the second (0-59)

  Full Restore Example

  db2 restore db database_name load '/opt/commvault/Base/libDb2Sbt.so' taken at backup_image_timestamp

  Incremental and Differential Restore Example

  db2 restore db database_name incremental automatic load '/opt/commvault/Base/libDb2Sbt.so' taken at backup_image_timestamp