CL492 IBM DB2 9 for LUW Advanced Database Recovery

Course Overview

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.

Who Should Attend

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.

Course Outline

1 - 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

2 - 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

3 - 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

4 - 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

Enroll Today

This is a 4-day class

Price: $2,895.00
Payment Options

ILT Instructor‑Led Training


GTR  Guaranteed to Run

Class times are listed Eastern time. This class is available for Private Group Training

To sort by location or date, click the ‘When’ and ‘Where’ column headings.

Class dates not listed.
Please contact us for available
dates and times.