Redpaper DB2 9 for z/OS Data Sharing: Distributed Load Balancing and Fault Tolerant Configuration
Hi DB2 User,
IBM just published a new Redpaper, "DB2 9 for z/OS Data Sharing: Distributed Load Balancing and Fault Tolerant Configuration, REDP-4449-00":
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
More information about Data Sharing
- Redbook DB2 for z/OS: Data Sharing in a Nutshell, SG24-7322-00
DB2 for z/OS takes advantage of data sharing technology in a z Parallel Sysplex to provide applications with full concurrent read and write access to shared DB2 data. Data sharing allows users on multiple DB2 subsystems, members of a data sharing group, to share a single copy of the DB2 catalog, directory, and user data sets.
Data sharing provides improvements to availability and capacity without impacting existing applications.
The road to data sharing might seem arduous to a novice user, but once you have started to learn terminology and gain basic understanding, things will become much easier.
This IBM Redbook is meant to facilitate your journey towards data sharing by providing a cookbook approach to the main tasks in enabling data sharing and workload balancing. It does not have all the answers, because it is a brief summary of a large field of knowledge, but it contains the key elements and it points you in the right direction to get more details. Throughout this document we assume that your sysplex environment is set up and a DB2 subsystem exists at a currently supported level.
Table of Contents
Chapter 1. Introduction
Chapter 2. Data sharing architecture
Chapter 3. The coupling facility
Chapter 4. Implementing data sharing
Chapter 5. Dynamic workload balancing
Chapter 6. Operations
Chapter 7. Advanced topics
Chapter 8. Best practices