DB2 9 for LUW Advanced Database Recovery

course content details

	DB2 Database Recovery Review:

This lecture will review the basic concepts and facilities involved in DB2 Database recovery that were covered in the student's prerequisite DB2 Database Administration Course. In the lab exercise, the student will configure the DB2 logs to support a specific application.

	DB2 Recovery Log Management:

	Dropped Table Recovery:

This lecture will describe the DB2 facility to recover from an SQL DROP TABLE statement issued in error, including implementing dropped table recovery for selected table spaces and using the DB2 LIST HISTORY command to gather the information needed to recover a dropped table. This lab exercise will demonstrate the ability to recover a single table's data online after being DROPed.

	Database Rebuild Support:

This unit describes the option of the RESTORE Utility to REBUILD a database. The processing for a disaster recovery and a partial database recovery using the standard recovery option available prior to DB2 9 will be reviewed. Recovery options like performing database recovery using a set of table space backup images instead of using a database backup image will be explained. The use of the REBUILD option to simplify a series of different recovery scenarios will be presented. Students will also learn how to monitor the database rebuild processing using the LIST UTILITIES command. This unit will include the special considerations for rebuilding a partial database that only includes a specific list of table spaces. Planning for rebuilding partitioned DB2 databases and nonrecoverable databases will be explained. The lab exercise allows the student to recover a subset of the table spaces in a database and then later complete the recovery or the excluded table space.

	Table space Recovery:

The lecture describes the planning and considerations for doing point in time recovery of selected table spaces. The usage of the QUIESCE command to establish a consistent point in time for recovery will be described. This lab will take the student through a recovery scenario to better understand the implications of recovering a DB2 database after a Point in Time Rollforward for a selected table space has completed.

	Incremental Backup and Restore:

This lecture will describe the DB2 backup options for creating incremental database and table space backup images to reduce the duration of the backup processing and the size of the backup image. The lab will let the student experience the use of the incremental database and table space backup images for automatic and manual incremental restoring of table spaces.

	DB2 Database Crash Recovery:

This lecture will describe database configuration parameters that effect crash recovery, including parallel recovery processing. The handling of offline table spaces will also be described. This lab exercise will allow the student to review the messages created during a DB2 database restart that performs crash recovery processing. One exercise will measure the impact of the softmax DB2 database configuration option on the performance of database crash recovery.

	DB2 Database and Table Space Relocation:

The lecture will describe the option of the Restore Utility to alter the containers for selected table spaces during the restore process. Topics include using the SET TABLESPACE CONTAINERS command to define new containers during a redirected restore and using redirected restore as part of a disaster recovery. The relocation of the automatic storage managed table spaces will be explained. This lab exercise provides the student with experience using the REDIRECT option of the Restore command in two different situations, using a Redirected Restore to add a container for an SMS table space and performing a Redirected Restore to replace a container for a DMS table space, both using the CLP commands. The db2relocatedb command will be used to update the DB2 database configuration to reflect container changes made with operating system facilities.

	DB2 Additional Recovery Facilities:

The lecture describes the LOAD Utility options COPY YES, COPY NO and NONRECOVERABLE impact on database recovery. Other topics include protecting the database from loss of log files, using the DB2 ARCHIVE LOG command to make the current DB2 log available for archival and implementing the DB2 option for blocking update transactions when the log disk becomes full. The option of the DB2 Backup Utility to include the active logs associated with an online backup will be explained. Several autonomic management options will be presented, including automation of database backups and options to limit the performance impact of database backups on the applications using the database. The lab exercise is an online lab which allows the student to test the three recovery modes for the DB2 LOAD Utility: COPY YES, COPY NO and NONRECOVERABLE. One exercise will demonstrate the option to bypass the closing of the active log by an online backup. The student will also implement log mirroring and use the mirror copy of the logs for Crash recovery processing.

	DB2 Recovery History File:

The lecture will describe the contents of the DB2 Recovery History file and how to use the information in planning and executing various DB2 utilities for database recovery. Other topics include using the PRUNE HISTORY command to remove outdated information in the Recovery History.

	DB2 High Availability and Split Mirror Database Copy:

This lecture will describe the DB2 High Availability options including implementing automated server failover using a cluster of servers. DB2 support for split mirror database copies will be explained, including using the SET WRITE SUSPEND/RESUME and db2inidb commands with split mirrors. This lab exercise allows the student use the suspend I/O commands combined with operating system file copies to establish a snapshot database that can be used to run applications and also to restore a damaged production database from a split mirror using the db2inidb command.

	Basic Database Disaster Recovery Techniques:

This lecture will describe three alternative methods for recovery of a DB2 for Linux, UNIX and Windows database as part of a disaster recovery, including log shipping, DB2 replication, and remote disk mirroring. The lab exercise will allow the student to set up database log shipping to a standby database that could quickly recover from a disaster situation.

	DB2 High Availability Disaster Recovery (HADR):

This lecture will describe the planning, implementation, and management of Primary and Standby databases using the DB2 HADR facility. The lecture will discuss the impact of using HADR on DB2 utilities including LOAD, backup and restore and REORG. The lab exercise will allow the student to set up a Primary and Standby database that can be used to quickly take over the application workload in the event of a partial or full database failure.

	DB2 DPF Partitioned Database Recovery Considerations:

This lecture will describe the considerations for the DB2 commands and utilities when recovering a DB2 DPF partitioned database.

	Day 1

	Unit 1 - DB2 Database Recovery Review
	Lab 1 - Configuring DB2 for Recovery
	Unit 2 - DB2 Recovery Log Management
	Lab 2 - Managing DB2 Log Files
	Unit 3 - Dropped Table Recovery
	Lab 3 - DB2 Dropped Table Recovery

	Day 2

	Unit 4 - Database Rebuild Support
	Lab 4 - Database Rebuild Support
	Unit 5 - Table Space Recovery
	Lab 5 - Table Space Point-in-Time Recovery
	Unit 6 - Incremental Backup and Recovery
	Lab 6 - Incremental Backup and Restore
	Unit 7 - DB2 Database Crash Recovery

	Day 3

	Lab 7 - Database Crash Recovery
	Unit 8 - DB2 Database and Table Space Relocation
	Lab 8 - DB2 Table space Relocation
	Unit 9 - DB2 Additional Recovery Facilities
	Lab 9 - Additional Recovery Facilities
	Unit 10 - DB2 Recovery History File
	Unit 11 - High Availability and Split Mirror Database Copy

	Day 4

	Lab 10 - DB2 High Availability using split mirror copies
	Unit 12 - Basic Database Disaster Recovery Techniques
	Lab 11 - DB2 Database Disaster Recovery using Log Shipping
	Unit 13 - DB2 High Availability Disaster Recovery (HADR)
	Lab 12 - DB2 High Availability Disaster Recovery (HADR)
	Unit 14 - DB2 DPF Partitioned Database Recovery Considerations