Reliability and Performance with IBM DB2 Analytics Accelerator V4.1

A draft IBM Redbooks publication


The IBM® DB2® Analytics Accelerator for IBM z/OS® is a high-performance appliance which integrates the IBM zEnterprise® infrastructure and the IBM Netezza® technology. With this integration, you can accelerate data-intensive and complex queries in a DB2 for z/OS highly secure and available environment.

DB2 and the Analytics Accelerator appliance form a self-managing hybrid environment running online transaction processing and online transactional analytical processing concurrently and efficiently. These online transactions run together with business intelligence and online analytic processing workloads.

DB2 Analytics Accelerator V4.1 expands the value of high-performance analytics. DB2 Analytics Accelerator V4.1 opens to static Structured Query Language (SQL) applications and row set processing, minimizes data movement, reduces latency, and improves availability.

This IBM Redbooks® publication provides technical decision-makers with an understanding of the benefits of version 4.1 of the Analytics Accelerator with DB2 11 for z/OS. It describes the installation of the new functions, and the advantages to existing analytical processes as measured in our test environment. This book also introduces the DB2 Analytics Accelerator Loader V1.1, a tool that facilitates the data population of the DB2 Analytics Accelerator.

Table of contents

Chapter 1. The analytics lifecycle
Chapter 2. Database design considerations
Chapter 3. Overview of IBM DB2 Analytics Accelerator V4.1
Chapter 4. Installation and maintenance procedures
Chapter 5. Query enhancements
Chapter 6. Load and incremental update
Chapter 7. Online data archiving
Chapter 8. High availability, disaster recovery, and balancing workloads
Chapter 9. Monitoring enhancements
Chapter 10. The Accelerator Loader
Appendix A. Preparing input data for Accelerator Loader


These pages are Web versions of IBM Redbooks- and Redpapers-in-progress. They are published here for those who need the information now and may contain spelling, layout and grammatical errors.

This material has not been submitted to any formal IBM test and is published AS IS. It has not been the subject of rigorous review. Your feedback is welcomed to improve the usefulness of the material to others.

IBM assumes no responsibility for its accuracy or completeness. The use of this information or the implementation of any of these techniques is a customer responsibility and depends upon the customer's ability to evaluate and integrate them into the customer's operational environment.


Last Update
14 August 2014

Planned Publish Date
31 August 2014

Rating: Not yet rated




IBM Form Number

Number of pages