13.8. The Recovery History File

DB2 keeps tracks of all the backup, restore, and roll forward operations performed in a file called db2rhist.asc, also known as the recovery history file. There is a recovery history file for each database, and it is stored in the directory where the database resides. The file is automatically updated when any of the following events occurs:

  • A database or table space is backed up

  • A database or table space is restored

  • A database or table space is rolled forward

  • A table space is created

  • A table space is altered

  • A table space is quiesced

  • A table space is renamed

  • A table space is dropped

  • A table is loaded

  • A table is dropped

  • A table is reorganized

To see the entries in the recovery history file, use the LIST HISTORY command. ...

Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial