The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

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.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

DB2 pureScale enablement

Workload balancing, automatic client reroute, and client affinities

Charlie Wang (charliew@ca.ibm.com), Advisory Software Engineer, IBM

Charlie Wang works for Systems Optimization Competency Center at IBM Toronto Lab with recent focus on system integration and optimization. He has worked on various DB2 development projects including DB2 pureScale since 2001.

Mike Springgay (springga@ca.ibm.com), Senior Development Manager, IBM　　

Mike Springgay is a Senior Development Manager within the DB2 for Linux, UNIX, and Windows development team. He joined the DB2 development team 15 years ago and is currently responsible for client server connectivity, routine infrastructure and monitor areas.

Aslam Nomani (aslam@ca.ibm.com), Quality Assurance Architect, IBM Toronto Lab

Aslam Nomani has been with IBM for 14 years with most of that time spent with the Quality Assurance team. His main area of focus has been on high availability and disaster recovery solutions. Over the past several years Aslam has been the Quality Assurance Architect for the DB2 pureScale feature.

Frankie Sun (sun@ca.ibm.com), Advisory Software Engineer, IBM

Frankie 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.

Summary: This paper describes the concept of DB2 workload balancing (WLB) and client affinities. This paper provides detailed examples to illustrate how to enable and use these features to access DB2 pureScale cluster from WebSphere Application Server and various stand-alone DB2 clients. This paper also demonstrates how automatic client reroute (ACR) routes application requests among pureScale members when an outage occurs. In addition, this paper provides tips on how to recover from a non-responsive TCP/IP layer along with how to provide alternate servers for the first connection to ensure successful access to the DB2 pureScale database.

Date: 28 Jun 2012
Level: Intermediate

Activity: 6944 views
Comments:

Get the download

The DB2 pureScale Feature for Enterprise Server Edition provides a database solution that meets the needs of the most demanding customers. It is designed to scale effectively to meet the growing and dynamic needs of different organizations. You can start additional members in the DB2 pureScale environment without any impact to existing applications to meet the demands of peak processing times. The DB2 pureScale Feature automatically balances the workload across all DB2 members in the cluster without any changes at the application side, taking full advantage of the additional processing capacity.

In this white paper

Executive summary
Introduction
Enabling WLB and client affinities with WebSphere Application Server
Enabling WLB and client affinities for stand-alone Java applications
Enabling WLB and client affinities for non-Java applications
Configuring alternate servers for the first connection
Enabling fast detection for unresponsive TCP/IP connections
Conclusion
Resources

Download

Description	Name	Size	Download method
White paper in PDF format	wlb.pdf	936 KB	HTTP

Information about download methods Get Adobe® Reader®

Resources

Learn

Visit the DB2 Version 10.1 for Linux, UNIX, and Windows Information Center to learn more about Java client support of high availability (WLB, ACR, and client affinities) connections to DB2 for Linux, UNIX, and Windows servers.
Visit the DB2 Version 10.1 for Linux, UNIX, and Windows Information Center to learn more about non-Java client support of high availability (WLB, ACR, and client affinities) connections to DB2 for Linux, UNIX, and Windows servers.
Visit the DB2 Version 10.1 for Linux, UNIX, and Windows Information Center to learn more about DB2 client considerations with the DB2 pureScale feature.
Visit the DB2 Version 10.1 for Linux, UNIX, and Windows Information Center to learn more about the db2dsdriver configuration file.
Visit the DB2 Version 10.1 for Linux, UNIX, and Windows Information Center to learn more about WLB support for embedded SQL and DB2 CLP applications that are bound with the KEEPDYNAMIC NO parameter.
Follow developerWorks on Twitter.
Watch developerWorks on-demand demos advanced functionality for experienced developers.

Get products and technologies

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.

Discuss

Participate in the discussion forum.
Get involved in the My developerWorks community. Connect with other developerWorks users while exploring the developer-driven blogs, forums, groups, and wikis.

Biographies

Comments