January 2005
Beginner to intermediate
928 pages
22h 14m
English
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. ...
Read now
Unlock full access