October 2004
Intermediate to advanced
688 pages
16h 35m
English
• "Database recovery concepts
• Logging
• Image copies
• Data recoveries
• Disaster recoveries
• System-level backup/recovery
• DB2 restart
DB2 has several methods for recovering data in the event of failures or when errors occur or disaster strikes. DB2 allows you to recover data to the current state or to an earlier state.
Many of the objects in DB2 can be recovered using various methods. You can recover
• Table spaces
• Index spaces
• Indexes
• Partitions of a table space
• Individual data sets
• Pages within an error range
• Individual pages
In order to ensure consistent operation and integrity of data, a DBA must develop a strategy for several recovery scenarios. These scenarios ...