DB2 10 for LUW HADR – Industry Leader in High Availability Disaster Recovery

Learning more about DB2 10 for LUW shows that this new release continues DB2’s leadership for reliability, availability and scalability over the rest of the DBMS industry options.  In the previous weeks I have highlighted several of the other new features and today I would like to talk about the new DB2 10 for LUW high availability disaster recovery (HADR) features.

First, if you are not familiar with the DB2 10 for LUW HADR, it has been in DB2 LUW for years now through a couple of versions and many companies are already leveraging it to provide HADR solutions for their 24/7/365 applications.  What makes the new DB2 10 for LUW HADR enhancements so industry-leading is the flexibility it offers the database and enterprise architect for designing their high availability disaster recovery high performance solutions for high availability databases.

DB2 10 for LUW HADR improves on all the existing DB2 HADR features: all types of hot/warm system standby configuration options, easy setup, and great fast failover with zero data loss.   DB2 HADR is also cost effective because it is free in most cases for a basic DB2 10 for LUW HADR standby system configuration and operation with your DB2 10 for LUW license.  The DB2 HADR feature also provides additional functionality since the standby system can also be used as a read-only system for all types of queries while it is the standby option.  This provides great query performance relief by moving any queries off your high availability transaction system. Even if your DB2 10 for LUW HADR application requires the extreme full hot/hot standby solution, minimal licensing charges compared to other databases, make DB2 10 for LUW the most cost effective HADR solution.

Another new feature within DB2 10 for LUW HADR is that a time delay can be set up between the main system and the hot backup system.  This time delay provides a way to prevent an error situation on the main system from being replicated to the backup system.  This delay can be adjusted within the DB2 10 for LUW HADR configuration and the backup system can then take over the primary processing functionality within your environment for your high availability database.

Next, DB2 10 for LUW HADR takes it to the next level of availability by allowing multiple hot system backups within your DB2 HADR solution configuration.  This means that your enterprise architects or DBAs can set up multiple systems at multiple locations to back up your primary system.  By having multiple standby systems, DB2 10 for LUW HADR provides a way to spread the primary database information to a primary standby system and up to two other auxiliary standby systems.  Also, these auxiliary standby systems can be spread across the data center or across the ocean providing all types of business high availability and disaster recovery options.

These DB2 10 for LUW HADR flexible features lead the DBMS industry with functionality and options to architect the easiest-to-configure and most cost-effective HADR environment for any type of robust transaction availability and disaster recovery requirements. Make sure to consider these DB2 10 for LUW HADR features for your next high availability database application.


Dave Beulke is an internationally recognized DB2 consultant, DB2 trainer and education instructor.  Dave helps his clients improve their strategic direction, dramatically improve DB2 performance and reduce their CPU demand saving millions in their systems, databases and application areas within their mainframe, UNIX and Windows environments.

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>