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)
db2 restore db <database_name> load '/opt/commvault/Base/libDb2Sbt.so' taken at <backup_image_timestamp>
db2 restore db <database_name> incremental automatic load '/opt/commvault/Base/libDb2Sbt.so' taken at <backup_image_timestamp>