IBM Db2 Analytics Accelerator V7 High Availability and Disaster Recovery

IBM Db2 Analytics Accelerator V7 High Availability and Disaster Recovery

by Ute Baumbach, Frank Neumann
Released October 2020
Publisher(s): IBM Redbooks
ISBN: 9780738457680

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

IBM® Db2® Analytics Accelerator is a workload optimized appliance add-on to IBM DB2® for IBM z/OS® that enables the integration of analytic insights into operational processes to drive business critical analytics and exceptional business value. Together, the Db2 Analytics Accelerator and DB2 for z/OS form an integrated hybrid environment that can run transaction processing, complex analytical, and reporting workloads concurrently and efficiently.

With IBM DB2 Analytics Accelerator for z/OS V7, the following flexible deployment options are introduced:


  • Accelerator on IBM Integrated Analytics System (IIAS): Deployment on pre-configured hardware and software
  • Accelerator on IBM Z®: Deployment within an IBM Secure Service Container LPAR

For using the accelerator for business-critical environments, the need arose to integrate the accelerator into High Availability (HA) architectures and Disaster Recovery (DR) processes. This IBM Redpaper™ publication focuses on different integration aspects of both deployment options of the IBM Db2 Analytics Accelerator into HA and DR environments. It also shares best practices to provide wanted Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO).

HA systems often are a requirement in business-critical environments and can be implemented by redundant, independent components. A failure of one of these components is detected automatically and their tasks are taken over by another component. Depending on business requirements, a system can be implemented in a way that users do not notice outages (continuous availability), or in a major disaster, users notice an outage and systems resume services after a defined period, potentially with loss of data from previous work.

IBM Z was strong for decades regarding HA and DR. By design, storage and operating systems are implemented in a way to support enhanced availability requirements. IBM Parallel Sysplex® and IBM Globally Dispersed Parallel Sysplex (IBM GDPS®) offer a unique architecture to support various degrees of automated failover and availability concepts.

This IBM Redpaper publication shows how IBM Db2 Analytics Accelerator V7 can easily integrate into or complement existing IBM Z topologies for HA and DR.
If you are using IBM Db2 Analytics Accelerator V5.1 or lower, see IBM Db2 Analytics Accelerator: High Availability and Disaster Recovery, REDP-5104.

Table of contents

  1. Front cover
  2. Notices
    1. Trademarks
  3. Preface
    1. Authors
    2. Now you can become a published author, too!
    3. Comments welcome
    4. Stay connected to IBM Redbooks
  4. Chapter 1. Business continuity and disaster recovery
    1. 1.1 Recovery time objective
    2. 1.2 Recovery point objective
  5. Chapter 2. High availability and disaster recovery in IBM Z enterprise environments concepts
    1. 2.1 Storage failures and synchronous and asynchronous data mirroring
    2. 2.2 Db2 Active-Active configuration with GDPS Metro
    3. 2.3 Db2 Active-Passive configuration with GDPS Global
    4. 2.4 Db2 Active-Passive configuration with GDPS Metro
    5. 2.5 Db2 multi-site configurations and tests
  6. Chapter 3. Introducing high availability concepts for IBM Db2 Analytics Accelerator
    1. 3.1 Workload balancing
      1. 3.1.1 Directing queries to specific accelerators
    2. 3.2 Data maintenance and synchronization with multiple accelerators
      1. 3.2.1 Loading into multiple accelerators by using the ACCEL_LOAD_TABLES stored procedure
      2. 3.2.2 Loading into multiple accelerators using Db2 Analytics Accelerator Loader
      3. 3.2.3 Loading into multiple accelerators using the HA Load sample program of Db2 Analytics Accelerator
      4. 3.2.4 Loading a subset of data
      5. 3.2.5 Using accelerator-only tables with multiple accelerators
      6. 3.2.6 Loading accelerator only data with Db2 Analytics Accelerator Loader
      7. 3.2.7 Incremental Update into multiple accelerators
    3. 3.3 HA setup for incremental update
      1. 3.3.1 HA setup for incremental update using Integrated Synchronization
      2. 3.3.2 HA setup for incremental update using CDC
    4. 3.4 High-performance storage saver and multiple accelerators
    5. 3.5 Federation with multiple accelerators
    6. 3.6 Definition of accelerators in Db2 catalog tables
  7. Chapter 4. Combining versions and deployment platforms
    1. 4.1 Combining V5 and V7 Accelerators
    2. 4.2 Similarities and differences of IIAS and Z deployments for V7 Accelerators
  8. Chapter 5. Planning for HA and DR with IBM Db2 Analytics Accelerator on IIAS
    1. 5.1 Stand-by accelerators
    2. 5.2 Network setup options
    3. 5.3 Latency and bandwidth requirements
    4. 5.4 Db2 active-active configuration with GDPS Metro and active accelerators
      1. 5.4.1 Data maintenance by using regular load cycles
      2. 5.4.2 Data maintenance by using incremental update
      3. 5.4.3 High-performance storage saver
    5. 5.5 Db2 active-standby configuration with GDPS Metro and active accelerators
    6. 5.6 Db2 active-standby configuration with GDPS Global and active accelerators
      1. 5.6.1 Data maintenance by using regular load cycles
      2. 5.6.2 Data maintenance by using incremental update
      3. 5.6.3 High-performance storage saver
    7. 5.7 Db2 active-standby configuration with GDPS Global and limited bandwidth to remote accelerator
    8. 5.8 Combined Db2 active-active-standby environment with GDPS Metro and GDPS Global and accelerators
    9. 5.9 Built-in HA features within IBM Db2 Analytics Accelerator on IIAS
  9. Chapter 6. Planning for HA and DR with IBM Db2 Analytics Accelerator on Z
    1. 6.1 IBM Z integration, network, and storage management
    2. 6.2 Network setup options
    3. 6.3 Latency and bandwidth requirements
    4. 6.4 Storage failures and HyperSwap
    5. 6.5 Active-passive configuration with standby Accelerator and GDPS Metro
    6. 6.6 Active-active configuration with capacity growth
    7. 6.7 Multi-site configurations with active and passive accelerators and GDPS
  10. Chapter 7. Summary
  11. Back cover

Product information

  • Title: IBM Db2 Analytics Accelerator V7 High Availability and Disaster Recovery
  • Author(s): Ute Baumbach, Frank Neumann
  • Release date: October 2020
  • Publisher(s): IBM Redbooks
  • ISBN: 9780738457680