Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

  • Close [x]

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

Configuring geographically dispersed DB2 pureScale clusters

Jeremy Brumer (jabrumer@ca.ibm.com), DB2 pureScale System Verification Test, IBM
Jeremy Brumer is the team lead for the DB2 pureScale System Verification Test organization, and is based at the IBM Canada Lab. He has over 10 years experience with DB2 products, and has been focused for the last several years on high availability solutions, including HADR, Microsoft Failover Clustering, and DB2 pureScale.
Roy Cecil (roy.cecil@ie.ibm.com), DB2 Performance Team, IBM
Roy Cecil photo
Roy Cecil has 10 years of experience in Software Development and Software and Systems Performance Engineering. He has been working since 2008 on DB2 V9.8 performance improvement, and most recently on improving the DB2 Recovery Performance. Roy is also an expert in UNIX and database systems and is based out of the Dublin Software Labs in Ireland. .
Fabrizio Fabbri (fabrizio.fabbri@ie.ibm.com), DB2 Software Development Team, IBM
Fabrizio Fabbri photo
Fabrizio Fabbri is a software developer and works with the DB2 kernel development team. He is currently working with the DB2 pureScale development team on cluster management and shared file system integration.
Steve Rees (srees@ca.ibm.com), Senior Performance Manager, IBM
Steve Rees photo
Steve Rees is Senior Performance Manager for DB2 pureScale software. He has worked on DB2 performance for over 15 years, with the last three on DB2 pureScale software.

Summary:  Because disasters like power failures and fires might easily disable a single data center, many large IT organizations configure two sites, far enough apart to be on separate power grids. This configuration minimizes the risk of total outage, and allows business to carry on at one site, even if the other is impacted by a disaster.

Date:  21 Apr 2011
Level:  Intermediate

Activity:  4535 views
Comments:  

This article describes the geographically dispersed DB2® pureScale™ cluster (GDPC). Like the Geographically Dispersed Parallel Sysplex™ configuration of DB2 for z/OS®, GDPC provides the scalability and application transparency of a regular single-site DB2 pureScale cluster, but in a cross-site configuration that enables active/active system availability, even in the face of many types of disasters.

The active/active part is important because it means that during normal operation, the DB2 pureScale members at both sites are sharing the workload between them as usual, with workload balancing (WLB) maintaining an optimal level of activity on all members, both within and between sites. This means that the second site is not a standby site, waiting for something to go wrong. Instead, the second site is pulling its weight, returning value for investment even during day-to-day operation.

This article describes the prerequisites for a geographically dispersed DB2 pureScale cluster, followed by the steps to one deploy one, as well as some of the performance implications of different site-to-site distances and different workload types.

The article covers the following topics:

  • GDPC concepts
  • GDPC infrastructure and prerequisites
  • GDPC setup and configuration
  • Performance factors
  • Detailed configuration steps

Download

DescriptionNameSizeDownload method
Article in PDF formatDBP_pureScale_GDPC_0419.pdf820KBHTTP

Information about download methods          Get Adobe® Reader®


Resources

Learn

Get products and technologies

Discuss

Biographies

Jeremy Brumer is the team lead for the DB2 pureScale System Verification Test organization, and is based at the IBM Canada Lab. He has over 10 years experience with DB2 products, and has been focused for the last several years on high availability solutions, including HADR, Microsoft Failover Clustering, and DB2 pureScale.

Roy Cecil photo

Roy Cecil has 10 years of experience in Software Development and Software and Systems Performance Engineering. He has been working since 2008 on DB2 V9.8 performance improvement, and most recently on improving the DB2 Recovery Performance. Roy is also an expert in UNIX and database systems and is based out of the Dublin Software Labs in Ireland. .

Fabrizio Fabbri photo

Fabrizio Fabbri is a software developer and works with the DB2 kernel development team. He is currently working with the DB2 pureScale development team on cluster management and shared file system integration.

Steve Rees photo

Steve Rees is Senior Performance Manager for DB2 pureScale software. He has worked on DB2 performance for over 15 years, with the last three on DB2 pureScale software.

Comments



Help: Update or add to My dW interests

What's this?

This little timesaver lets you update your My developerWorks profile with just one click! The general subject of this content (AIX and UNIX, Information Management, Lotus, Rational, Tivoli, WebSphere, Java, Linux, Open source, SOA and Web services, Web development, or XML) will be added to the interests section of your profile, if it's not there already. You only need to be logged in to My developerWorks.

And what's the point of adding your interests to your profile? That's how you find other users with the same interests as yours, and see what they're reading and contributing to the community. Your interests also help us recommend relevant developerWorks content to you.

View your My developerWorks profile

Return from help

Help: Remove from My dW interests

What's this?

Removing this interest does not alter your profile, but rather removes this piece of content from a list of all content for which you've indicated interest. In a future enhancement to My developerWorks, you'll be able to see a record of that content.

View your My developerWorks profile

Return from help

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=649225
SummaryTitle=Configuring geographically dispersed DB2 pureScale clusters
publish-date=04212011
author1-email=jabrumer@ca.ibm.com
author1-email-cc=
author2-email=roy.cecil@ie.ibm.com
author2-email-cc=
author3-email=fabrizio.fabbri@ie.ibm.com
author3-email-cc=
author4-email=srees@ca.ibm.com
author4-email-cc=