DB2 10 for LUW Advanced Database Recovery CL493G

Days: 4 day
Price: $2995

Course Details

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.

Course 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: 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

Details

Options