Overview

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. The course also presents usage of HADR with Db2 pureScale databases.

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

Skills Covered

Please refer to course overview.

Prerequisites

  • 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.
  • These skills can be developed by taking:
    • CL207  Db2 11.1 Administration Workshop for Linux or
    • CL487 Db2 11.1 quickstart for experienced relational DBAs

Target Audience

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

Course Curriculum

Course Outline

  • Db2 HADR Concepts and implementation
  • Db2 HADR Standby database management
  • Db2 HADR for pureScale

Dates & Locations

Let’s make it work for you

Can’t find a date that fits? Need to train your whole team? Looking for a discount?
Speak to one of our learning experts today.

x Clear all selections
Trainocate exam and cert

Exam & Certification

This course is not associated with any Certification.

Training & Certification Guide

Frequently Asked Questions

Speak to a Training Consultant

All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631

Preferred mode of training
Checkboxes