V11 SP8

DB2 Command Line Example: Performing an In-place Restore

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


  • 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:


    • 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 Example

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

    Incremental Example

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