Articles & Content

Archives

DB2 9 & DB2 9.5 Recovery Enhancements - Routes to Happiness! (D05)

Topic: DB2 for LUW

Subtopic: 2008



DATE: 2008-10-14 (11:45 - 12:45)
SPEAKERS: Melanie Stopfer (IBM Software Group)

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

EXP. LEVEL: Beginner,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.