Articles & Content

Archives

DB2 LUW Recovery Enhancements - Routes to Happiness! (E14)

Topic: DB2 for LUW

Subtopic: 2009



DATE: 2009-5-15 (10:30 AM - 11:30 AM)
SPEAKERS: Melanie Stopfer (IBM Software Group)

DB2 has recently introduced new options for BACKUP, RESTORE, ROLLFORWARD and RECOVER. Do you know how to recover a database using only a subset of tablespace backups? Database Rebuild support can reduce disk space required to make data copies for testing or recovering dropped tables, dropped tablespaces or point in time recovery to correct application errors. Are you familiar with TO END OF BACKUP to restore a backup that does not require any other log files? Can you configure DB2 to automatically delete backup images, load copy images, and old log files that are no longer needed? Can you implement new Data Partitioning Feature enhancements to simplify your recovery? Attend this presentation and learn the Routes to Recovery Happiness!

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Explain the advantages of using the REBUILD option for the RESTORE command.

Configure DB2 to automatically delete backup images, load copy images, and old log files that are no longer needed for recovery.

Utilize TO END OF BACKUP option to restore a backup that does not require any other log files.

Implement new Data Partitioning Feature enhancements to simplify your recovery procedures

Gain knowledge of all the new DB2 9 and DB2 9.5 Recovery Enhancements



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.