CL49: DB2 10.5 for LUW Advanced Database Recovery

Code: CL49
Duration: 4 days


This course is designed to gain a deeper understanding of the advanced recovery features of DB2 10.5 for LUW database environments with single and multiple partition databases. Get practical experience in the planning and utilization of a wide variety of DB2 10.5 recovery facilities in a series of database recovery scenarios you complete during lab exercises using DB2 Enterprise 10.5 for Linux.


Upon successful completion of this course, the students will be able to:

  • Describe the unique recovery planning requirements for DB2 10.5 single partition and DPF multiple partition databases
  • Explore the DB2 for LUW 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
  • Gain a better understanding of DB2 database crash recovery processing
  • Utilise 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
  • Utilise the information in the DB2 recovery history file to plan and execute various DB2 utilities
  • Understand the benefits and limitations of disaster recovery alternatives including log shipping to a standby database or using DB2 replication
  • 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 LUW databases


Experienced database administrators who plan and implement recovery and high availability plans for DB2 10.5 for LUW databases using single or multiple partition DPF databases.


You should complete:

  • DB2 10.1 Database Administration Workshop for Linux (CL20) or
  • DB2 10.1 Database Administration Workshop for UNIX (CL21) or
  • DB2 10.1 Database Administration Workshop for Windows (CL23) or
  • Fast Path to DB2 10.1 for Experienced Relational DBAs (CL28) or
  • DB2 10.1 for Linux, UNIX, and Windows Quickstart for Experienced   Relational DBAs (CL48) or
  • DB2 9 for LUW Multiple Partition DBA Workshop (CL24) or
  • DB2 9 for LUW Multiple Partition Environment for Single Partition DBAs (CL25)
  • Or have equivalent experience


Classroom and hands on lab exercises. The lab exercises for a single partition database will be run on Windows operating system.

Course Schedule »