Creating an active-active data warehouse topology using IBM InfoSphere Warehouse

This article explains how you can create an active-active environment for IBM InfoSphere Warehouse to meet the highest availability requirements using DB2 for Linux, UNIX, and Windows, WebSphere Edge Components, and Q Replication.

Aruna De Silva (, QA-DB2 Data Warehouse and IM Solutions, IBM

Aruna De Silva  photoAruna De Silva is a member of the Quality Assurance (QA) team for DB2 on Linux, Unix, and Windows product at the IBM Toronto software laboratory. Aruna is an IBM Certified Advanced Database Administrator for DB2 9. In addition, he holds numerous IT certifications from IBM and other vendors in database, hardware, and systems administration. Aruna is actively involved in DB2 product integration, implementing and testing complex product stacks, and designing and testing HA and DR solutions. He is also the key contact person for EMC Storage within IBM Information Management Software division. He holds a Bachelor of Science degree in Computer Science from York University.

Enzo Cialini (, Senior Technical Staff Member, IBM

Enzo Cialini photoEnzo Cialini is a Senior Technical Staff Member in the IBM Information Management division at the IBM Toronto laboratory. He is currently the Chief Quality Assurance Architect responsible for management and technical test strategy for DB2 LUW (including Balanced Warehouse and Smart Analytics Systems), Information Management Solutions, and Customer Operational Profiling. Enzo joined IBM in 1991 and has been working on the DB2 development team since 1992. He has more than 20 years experience in software development, testing and support. Enzo established the DB2 Product Validation Program and has built established testing, development, and marketing relationships with such storage vendors as EMC, Veritas, and Network Appliance. He also authored The High Availability Guide for DB2 book and has published many papers on DB2, integration and data life cycle. He holds a Bachelor of Science degree in Computer Science from McMaster University.

21 October 2011

As data warehouses are now continually growing in supporting Tier 1 applications, you need fully integrated disaster recovery architecture. Traditional disaster recovery (DR) strategies involve a passive DR site that is not accessible for processing. However, companies are looking to leverage the additional hardware and software investments made in creating this DR site.

In this article

The purpose of this paper is to provide an active-active environment for IBM® InfoSphere® Warehouse by using IBM DB2® Version 9.7 for Linux®, UNIX®, and Windows® database servers to meet the increasing availability and performance requirements demanded in today's business environment.An active-active warehouse architecture addresses two distinct problem domains: continuous availability and disaster recovery.

WebSphere® Edge Components, part of IBM WebSphere Application Server Network Deployment (ND) offering, are typically used to control client access to Web servers. In this paper, we demonstrate how Edge Components can be used to load balance DB2 clients among multiple DB2 coordinators based on performance metrics or access control rules.

In addition, we describe how Q-replication is used to maintain two identical copies of DB2 V9.7 data servers in an active-active DB2 data warehouse topology. Finally, we examine some of the challenges associated with operating an active-active DB2 data warehouse and strategies to mitigate those issues.


Article in PDF formatActive-ActiveDWSoln.pdf1.02MKB
Zone=Information Management, Big data and analytics, WebSphere
SummaryTitle=Creating an active-active data warehouse topology using IBM InfoSphere Warehouse