Articles & Content

Archives

DB2 9 Database Rebuild Support & Recovery Enhancements (D07)

Topic: 2008 NA

Subtopic: DB2 for LUW



DATE: 2008-05-20 (01:30 PM - 02:30 PM)
SPEAKERS: Melanie Stopfer (IBM Software Group)

DB2 9 introduced new options for the RESTORE utility to recover a database using one or more table space backups. This functionality provides the ability to build a new database using a subset of the table spaces. This 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. Other DB2 9 Recovery Enhancements will also be addressed.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Explain the advantages of using the REBUILD option for the RESTORE command in DB2 9.

List the types of information included in each DB2 backup image and describe how it is used to support rebuilding a database.

Plan for supporting database and disaster recovery scenarios using DB2 database and table space backups using the RESTORE command with a REBUILD option.

Utilize LIST UTILITIES SHOW DETAIL to monitor progress of RESTORE utility during database rebuilding.

Describe other DB2 9 recovery enhancements including changes to rollforward database, backup image naming conventions, and redirected restore operation using an automatically generated script



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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