Skip to main content

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

An IBM Redpaper publication

Note: This is publication is now archived. For reference only.


Published on 17 July 2008, updated 13 May 2010

  1. .PDF (0.8 MB)

Share this page:   

IBM Form #: REDP-4449-00

Authors: James Pickel

    menu icon


    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


    Others who read this also read