View Printable Version

D10 - High Availability Two Step: HADR and Power-HA(HACMP)

Session Number: 1174
Track: DB2 for LUW - II
Session Type: Podium Presentation
Primary Presenter: Ember Crooks [Application Engineering Architect - Rosetta]

Camelback => Thu, May 15, 2014 (09:15 AM - 10:15 AM)

Speaker Bio: Ember Crooks is an Application Engineering Architect for Rosetta, where she plans, builds, and supports IBM WebSphere Commerce DB2 LUW databases for a range of clients. Ember has 12 years of experience as a database administrator, and was named as an IBM Champion in Information Management in 2013. She writes a popular DB2 LUW blog at, and has presented on the DB2Night show and at the IDUG 2013 North American technical conference.
Audience experience level: Beginner, Intermediate
Presentation Category: Managing Availability
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Database Administrators, New Users
Technical areas this presentation will apply to: High Availability (DB2 for LUW)
Objective 1: Understand HADR and the 4 HADR modes
Objective 2: Work through the details of HADR setup and common issues
Objective 3: Compare and contrast DB2 HADR to and Power HA (HACMP)
Objective 4: Demonstrate what is monitored and what exactly happens on HACMP failover
Objective 5: HACMP setup and gotchas from a DBA perspective
Co-speaker Name: Michael Krafick
Co-speaker Bio: Michael Krafick is a certified Sr. Database Administrator in Atlanta, GA with many years experience in Data Warehousing and Highly Transaction OLTP databases.

Michael is a frequent guest writer for Ember Crooks on the popular DB2 Blog. His recent articles are on topics such as Triaging 101, HACMP and DB2, Attack of the Blob, and DB2 in memory. He has also appeared on the DB2 Night show and was voted a "Top 10" User speaker at the 2012 IDUG Technical Conference in Denver.

Abstract:  In most production DB2 LUW implementations, a database administrator needs to investigate options for high availability or disaster recovery. In this session, we will be discussing two of the more common types of availability configurations - IBM's DB2 HADR feature compared to IBM's Power HA (more commonly known as HACMP). IBM Champion Ember Crooks will be discussing multiple HADR configurations, set-up, and common issues. Co-presenter Michael Krafick will be comparing HADR to IBM's Power HA (HACMP), discussing setup, configuration, as well as various tips and tricks. Learn the situations in which you might use one or the other, and even both!

For questions or concerns about your event registration, please contact