Other examples of DB2 backup, restore, and rollforward command options

Edit online

You can use the examples provided here of DB2 backup, restore, and rollforward command options.

In cases where you want to restore a database to a specific point in time and not roll forward any changes made after than point in time, the “without rolling forward” option will prevent DB2 from changing the restored database in rollforward pending state. 
db2 restore db ldapdb2 from /safeplace taken at 20040405154705 without rolling forward
To restore a database without prompting for a path that has only one backup database image stored, use the following command: 
db2 restore db ldapclog from /safeplace/full-backup-ldapclog without 
rolling forward without prompting
The command for offline rollforward database to a point in time: 
db2 rollforward database ldapdb2 to 2004-04-22-14.54.21.253422 and stop

This command rolls forward all logs located in the log folder specified in the database configuration file up to and including the point-in-time as stated in the example.The “and stop” key phrase completes the rollforward recovery process by rolling back incomplete transactions and tuning off the rollforward pending state of the database.