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 format||Active-ActiveDWSoln.pdf||1.02MKB|