Best Practices: Active Data Warehouse Topology using InfoSphere Warehouse
svisser1 2700018UK9 Visits (3023)
Thanks to Data Warehouse experts Aruna De Silva and Enzo Cialini for putting together this latest Best Practice article. This paper is called "Active-Active Data Warehouse Topology using InfoSphere Ware
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.
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.
Aruna De Silva is on the QA-DB2 Data Warehouse and IM Solutions team with IBM
Enzo Cialini is Senior Technical Staff Member, IBM
If this is your area of concern or expertise, read the full Best Practice Paper: Active-Active Data Warehouse Topology using InfoSphere Warehouse.
See also my previous posts on Best Practices: