DB2 9 for LUW Advanced Database Recovery

Gain a deeper understanding of the advanced recovery features of DB2 9 for Linux, UNIX, and Windows database environments with single and multiple partition databases. Get practical experience in the planning and utilization of a wide variety of DB2 recovery facilities in a series of database recovery scenarios you complete during lab exercises using DB2 Enterprise 9.5 for Linux.

Course Materials

The course materials cover DB2 9.5 for Linux, UNIX, and Windows.

Hands-On Labs

Twelve labs are included to address advanced usage of DB2 9.5 for Linux, UNIX, and Windows.

Certification

Prepare for IBM Certification Test 734: DB2 9 Advanced Database Administrator for Linux UNIX and Windows.

Training Path

This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education.

Experienced database administrators who plan and implement recovery and high availability plans for DB2 9 for Linux, UNIX and Windows databases using single or multiple partition DPF databases. The lab exercises can be performed using a single partition or a multiple partition DPF database using DB2 Enterprise 9.5 for Linux.

DB2 Database Recovery Review

• State the three types of recovery support
• Explain the basic principles DB2 uses for database recovery and restart
• Describe the capabilities and functional requirements of DB2 logging
• Select options for some of the DB2 database parameters that support recovery

DB2 Recovery Log Management

• Select the DB2 Database parameters that support the DB2 logs
• Configure the database options to automate archive log management
• Implement infinite active logging to support applications that require large amounts of logged database changes
• Describe the options provided by DB2 9 for Linux, UNIX, and Windows to reduce log volume, including the NOT LOGGED INITIALLY option

DB2 Dropped Table Recovery

• Explain the DB2 facility to recover from an SQL DROP TABLEstatement issued in error
• Implement dropped table recovery for selected table spaces
• Use the DB2 LIST HISTORY command to gather the information needed to recover a dropped table
• Plan and invoke the DB2 utilities involved in recovering a dropped table

Database Rebuild Support

• Review the considerations of using standard DB2 database recovery options
• Explain the capabilities of the REBUILD option for the RESTORE command
• 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 a RESTORE Utility during database rebuilding

Table Space Recovery

• Perform a point-in-time recovery of a table space
• Quiesce table spaces in share, update, and exclusive mode

DB2 Incremental Backup and Recovery

• Plan a database recovery strategy that includes both full and Incremental backups to reduce the duration and size of database backups
• Implement a physical database design to take advantage of Incremental backups of selected table spaces
• Utilize an Incremental restore to recover a DB2 database or table space from Incremental backup images
• Use the LIST UTILITIES command to track the processing of an Incremental backup or restore process

DB2 Database Crash Recovery

• Describe the concepts and processing for DB2 database crash recovery
• Select an appropriate value for SOFTMAX to reduce database crash recovery time
• Configure DB2 database options to support crash recovery for applications
• Describe the impact of a database crash and restart for DB2 Utilities like LOAD, REORG and IMPORT

DB2 Database and Table Space Relocation

• Explain the facility of the DB2 RESTORE command to recover table spaces to different containers
• Use the SET TABLESPACE CONTAINERS command to define new containers during a redirected restore
• Utilize the RESTORE utility to change the database storage paths for AUTOMATIC STORAGE table spaces
• Plan the use of redirected restore as part of a disaster recovery
• Use the GENERATE SCRIPT option of RESTORE to set up a command script for a redirected restore operation
• Use db2relocatedb when moving or copying DB2 databases with non-DB2 utilities

DB2 Additional Recovery Facilities

• Explain the LOAD Utility options COPY YES, COPY NO and NONRECOVERABLE impact on database recovery
• Select the appropriate method for protecting the database from loss of log file
• Select the BACKUP Utility option to include the required logs in an online backup image
• Use the DB2 ARCHIVE LOG command to make the current DB2 log available for archival
• Implement the DB2 option for blocking update transactions when the log disk becomes full
• Implement the DB2 Utility Throttle using the UTIL_IMPACT_LIM Database Manager configuration option
• Configure a DB2 database for automatic backups
• Explain the self optimizing features of the Backup Utility

DB2 Recovery History File

• Explain the information recorded in the Recovery History file
• Use the DB2 LIST HISTORY command to display selected information needed to plan database recovery
• Retrieve information from the database recovery history using SQL
• Configure a DB2 database for automatic removal of database recovery objects including backups and archived logs
• Use the PRUNE HISTORY command to remove outdated information in the Recovery History
• Restore a damaged Recovery History file

High Availability and Split Mirror Database Copy

• Describe various techniques for supporting High Availability of DB2 databases
• Explain the concepts involved when implementing the automated failover of a DB2 database
• Describe the integrated cluster configuration and management features of DB2
• Plan for using split mirror copies to create a standby database, a database snapshot or a database mirror
• Utilize the SET WRITE SUSPEND and DBD2INIDB commands with split mirror database copies
• Use the AS SNAPSHOT option of the DB2 BACKUP and RESTORE utilities

Basic Database Disaster Recovery Techniques

• Describe the benefits and limitations of several methods for supporting database disaster recovery
• Explain setup for a Standby database at a remote location
• Plan for database disaster recovery using remotely mirrored disks
• Describe the use of DB2 Replication to recover selected DB2 tables in a remote database

DB2 High Availability Disaster Recovery (HADR)

• Describe the benefits and limitations of implementing High Availability Disaster Recovery (HADR)
• Implement HADR, including the setup of a Primary and Standby database
• Use the commands START HADR, STOP HADR, and TAKEOVER to manage an operational HADR system
• Plan for the use of the DB2 Utilities like LOAD, REORG, Backup and Restore in an HADR environment
• Select appropriate HADR database configuration options in order to meet the requirements of a specific application environment including the HADR_PEER_WINDOW
• Monitor the status of the Primary and Standby database using GET SNAPSHOT FOR DATABASE or db2pd - hadr

DB2 DPF Partitioned Database Recovery Considerations

• Explain database recovery facilities in a DB2 DPF partitioned database
• Describe the use of the Single System View options for Backup of a partitioned database
• Recover a partitioned database using the TO END OF LOGS option of the ROLLFORWARD command
• Create an online Backup of a DPF partitioned database that includes all of the required active logs
• Implement automated archival of DB2 logs in a DPF partitioned database
• Perform dropped table recovery in a DPF partitioned database
• Use the REBUILD option of RESTORE to build a partial copy of a DPF Partitioned database
• Describe the crash recovery processing performed for a DPF partitioned database
• Explain the use of redirected restores and db2relocatedb with DPF partitioned databases
• Use db2inidb for split mirror copies with a DPF partitioned databases

Agenda

Day 1

• Unit 1: DB2 Database Recovery Review
• Exercise 1: Configuring DB2 for Recovery
• Unit 2: DB2 Recovery Log Management
• Exercise 2: Managing DB2 Log Files
• Unit 3: Dropped Table Recovery
• Exercise 3: DB2 Dropped Table Recovery

Day 2

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

Day 3

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

Day 4

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