DB2 backup history file overview

Edit online

DB2® provides its own history file that stores all information about backup, restore, and changes in the database (such as adding containers to a tablespace).

Issue one of these commands to list information from the backup history file:

     db2 list history backup all for <SID>

     db2 list history rollforward all for <SID>

For more information about the db2 list history command, see IBM® DB2 Command Reference.

To restore a backup that was performed on the local production system, you can find the timestamp of the backup with the db2 list history command.