The purpose of this course is to enable the learning to 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.
Describe the unique recovery planning requirements for DB2 9 single partition and DPF multiple 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
Implement Read-Only application access to the Standby database in a HADR environment
This advanced course is for 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 performe
- 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
- 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
- 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
- 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
Virtual CL492 IBM DB2 9 for LUW Advanced Database Recovery Online Live training option
Imagine an industry-leading classroom training experience from wherever you have access to the Internet.
The Virtual Online Live events listed here gives you an effective and proven online virtual learning experience with the freedom to attend virtually from anywhere.
There is also an option of experiencing Online Live from one of the many national partner centers where a computer and headset will be provided for you.
This rich and engaging virtual classroom environment lets you conveniently interact with instructors and other students.
You will hear and see your instructor as they teach the course and answer your questions via voice or text.
Choose the online live virtual training option and you can access the recorded version even after the class has finished.
The onDemand labs give you access to the same client and server technologies covered in class so you can test, apply and hone your skills by accessing the labs before and even after the class.
Technical Requirements: a computer or laptop with a modern browser and high speed internet access along with one or two monitors.