DB2 pureScale Feature

Workload balancing, automatic client reroute, and client affinities concepts and administration

The DB2 pureScale Feature keeps your distributed database system available 24x7. WLB, ACR, and client affinities provide uninterrupted service during both planned and unplanned outages. If a member fails, applications are automatically rerouted to other DB2 members. When the failed member comes back online, applications are transparently routed to the restarted member. With the DB2 pureScale Feature, scaling your database solution to meet the most demanding business needs is easy.

Frankie Sun (sun@ca.ibm.com), Staff Software Developer, IBM

Photo of author Frankie SunFrankie Sun has been a developer at the IBM Toronto Lab for the DB2 for Linux, UNIX, and Windows product since its early days. His expertise is in the area of connectivity. For DB2 pureScale, he was the lead developer for the workload balancing and automatic client reroute features.

Jason Woods (jdwoods@ca.ibm.com), Software Developer, IBM

Author photo of Jason WoodsJason Woods joined the DB2 for Linux, UNIX and Windows team 6 years ago as a software developer. Since then he has worked on various DB2 projects that include DB2 pureScale Feature, SQL compatibility, routine infrastructure and connectivity.

Jo-Ann Woods (jawoods@ca.ibm.com), Information Developer, IBM

Author photo of Jo-Ann WoodsJo-Ann Woods is an Information Developer for DB2 for Linux, UNIX, and Windows at the IBM Canada Lab in Toronto. She has over 10 years experience with DB2 products. Her areas of expertise include product installation, prerequisites, and fix pack documentation, and is currently responsible for DB2 pureScale Feature documentation.

25 April 2013

This article describes the IBM® DB2® pureScale Feature®. It offers clustering technology that helps reduce the risk and cost of business growth, with application cluster transparency, scalability, and continuous availability. Organizations that run online transaction processing (OLTP) applications on distributed systems can use DB2 pureScale Feature to scale a database solution. It also provides resiliency through workload balancing and automatic client reroute as driven by an IBM Data Server driver or client.

In this article

The purpose of this article is to highlight the main features of DB2 pureScale Feature.

You’ll learn about the following:

  1. IBM Data Server drivers and clients.
  2. Server lists.
  3. Member priority.
  4. Workload balancing (WLB).
  5. Automatic client reroute (ACR).
  6. First connection redundancy.
  7. Client affinities.
  8. Client affinities configuration reload.
  9. Advanced timeout configuration.
  10. Application considerations.
  11. Monitoring.
  12. Troubleshooting.


Article in PDF formatDB2_pureScale_Feature_WLB_ACR_Client_Affinities_concepts_and_admin.pdf335KB



Get products and technologies

  • Build your next development project with IBM trial software, available for download directly from developerWorks.
  • Evaluate IBM products in the way that suits you best: Download a product trial, try a product online, use a product in a cloud environment, or spend a few hours in the SOA Sandbox learning how to implement Service Oriented Architecture efficiently.


Zone=Information Management
SummaryTitle=DB2 pureScale Feature