Training offering
DB2 9 LUW Advanced Database Recovery
Description
Gain a deeper understanding of the advanced recovery features of DB2 9 for Linux, UNIX, and Windows database environments with single 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 for Linux.
Objectives
• Describe the unique recovery planning requirements for DB2 9 single partition partition databases
• Explore the DB2 for Linux, UNIX and Windows recovery facilities and database configuration options
• Plan the implementation of automated archival and retrieval of database logs
• Recover a DB2 table following a DROP TABLE command issued in error
• Utilize the REBUILD option of the RESTORE Utility to recover a full or partial database copy using either database or table space backups
• Plan and execute the recovery of table spaces to a selected point in time
• Effectively utilize incremental backup and restore to reduce the size and duration of DB2 database backups
• Describe the database crash recovery processing performed when there is an unplanned outage of a DB2 database server and select database configuration options to minimize the restart time.
• Utilize the redirected restore option to recover DB2 data to alternate disk configurations and invoke the db2relocatedb command to alter the configuration of a DB2 database
• Execute recovery scenarios, including loss of DB2 log data using the DB2 log mirroring option, and configure a database for automatic backups
• Utilize the information in the DB2 recovery history file to plan and execute various DB2 utilities
• Configure a DB2 database to automatically remove recovery objects that are no longer needed, including backups and archived logs
• List the benefits and limitations of disaster recovery alternatives including log shipping to a standby database or using DB2 replication
• Utilize the db2haicu command to select options for the integrated high availability cluster support for DB2 databases
• Explore the options for operation of DB2 databases in high availability environments including the use of a split mirror copy of the database
• Plan, implement, and manage the Primary and Standby databases using the High Availability Disaster Recovery (HADR) facilities of DB2 9 for Linux, UNIX and Windows databases
Participants
Experienced database administrators who plan and implement recovery and high availability plans for DB2 9 for Linux, UNIX and Windows databases using single partition databases. The lab exercises can be performed using a single partition database using DB2 Enterprise 9.5 for Linux.
Prerequisite(s)
You should complete:
• DB2 9 Database Administration Workshop for Linux (CL201) or
• DB2 9 Database Administration Workshop for UNIX (CL211) or
• DB2 9 Database Administration Workshop for Windows (CL231) or
• Fast Path to DB2 9 for Experienced Relational DBAs (CL281) or
• DB2 9 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs (CL481)
• Or have equivalent experience
Options
• DB2 Database Recovery Review
• DB2 Recovery Log Management
• DB2 Dropped Table Recovery
• Database Rebuild Support
• Table Space Recovery
• DB2 Incremental Backup and Restore
• DB2 Database Crash Recovery
• DB2 Database and Table Space Relocation
• DB2 Additional Recovery Facilities
• DB2 Recovery History File
• High Availability and Split Mirror Database Copy
• Basic Database Disaster Recovery Techniques
• DB2 High Availability Disaster Recovery (HADR)
