DB2 10 for LUW Advanced Database Recovery

This advanced course is for experienced database administrators who plan and implement recovery and high availability plans for DB2 10 for Linux, UNIX and Windows databases using single or multiple partition databases. The lab exercises can be performed using a single partition or a multiple partition database using DB2 Advanced Enterprise Edition 10.5 for Linux. This course is appropriate for those using DB2 in a z/Linux environment.

Please contact us for information about prerequisites.

Expected Duration
4 day


Gain a deeper understanding of the advanced recovery features of DB2 10 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 Advanced Enterprise Edition 10.5 for Linux.


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: DB2 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: DB2 Incremental Backup and Recovery
  • Exercise 6: Incremental Backup and Restore
  • Unit 7: DB2 Database Crash Recovery
  • Exercise 7: Database Crash Recovery

Day 3

  • 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: Using Split Mirror Database Copies
  • Exercise 10: Working with using split mirror database copies
  • Unit 11: High Availability Options for DB2 LUW

Day 4

  • Unit 12: DB2 High Availability Disaster Recovery (HADR) – Introduction
  • Exercise 11: Implementing a HADR Standby Database
  • Unit 13: DB2 High Availability Disaster Recovery (HADR) – Standby Database options
  • Exercise 12: Implementation of Multiple Standby databases and Reads on a Standby Database
  • Unit 14: DB2 pureScale Database Recovery Considerations
  • Unit 15: DB2 Partitioned Database Recovery Considerations



Select Course Options