DB2 9 for z/OS Data Sharing: Distributed Load Balancing and Fault Tolerant Configuration

An IBM Redpaper publication



Abstract

This IBM® Redpaper provides information about exploiting client load balancing and fail over capabilities across a DB2® data sharing group or a subset of the group members.
The information provided will help network specialists and data base administrators in appropriately configuring data sharing groups as TCP/IP servers.
We show how to use the functions of DB2 sysplex workload balancing functions, supported by DB2 Connect™ Server and the IBM DB2 Driver for JDBC and SQLJ, in conjunction with the functions of TCP/IP Sysplex Distributor, configured with Dynamic Virtual IP address (Dynamic VIPA or DVIPA) and automatic VIPA takeover, to provide superior load distribution and fail-over capability for transactions and connections across the members of a data sharing group. The two functions work together to ensure the highest availability possible for remote applications accessing a DB2 location in a sysplex.

Table of contents

Exploiting client load balancing across a DB2 group
Enabling sysplex workload balancing in DB2 client drivers
Configuring sysplex workload balancing for a subset of members



Profile

Publish Date
17 July 2008

Last Update
12 May 2010


Rating:
(based on 1 review)


Author(s)

IBM Form Number
REDP-4449-00

Number of pages
16