CL810G - DB2 11.1 HADR Workshop - 2 Days

Course Description

This course teaches database administrators how to plan, implement and manage Db2 11.1 databases using the High Availability Disaster Recovery HADR) feature. The lectures cover the processing performed for a Db2 Primary and Standby Db2 database. The Db2 database configuration options that define and control the HADR function are covered. The option to define and operate multiple HADR standby databases will be explained. The course also covers the special considerations for allowing read only access by applications to a HADR Standby database. Students will learn the Db2 commands like TAKEOVER, START HADR and STOP HADR that are used to control HADR primary and standby database activity. The monitoring for HADR status of the primary and standby databases using the db2pd commands will be presented.

Target Audience

This course is intended for students that will manage Db2 11.1 databases using the High Availability Disaster Recovery feature.

  • A working knowledge of Db2 11.1 database server management including backup and recovery operations, Db2 utility execution and database monitoring with db2pd commands.
  • Use basic Linux OS functions such as file management, file permissions, and text file editing.

Customisation

For on-site courses (i.e. at your premises), we are more than happy to tailor the course agenda to suit your exact requirements. In many cases, we are able to build your in-house standards and naming conventions into the delivered course.

Course Details

Course Topics
Db2 HADR Concepts and implementation
Db2 HADR Standby database management

Course Enquiry