Reliability and Performance with IBM DB2 Analytics Accelerator V4.1

A draft IBM Redbooks publication


The IBM® DB2® Analytics Accelerator for IBM z/OS® (simply called Accelerator in this book) is a high-performance appliance which integrates the IBM zEnterprise infrastructure and the IBM Netezza® technology to accelerate data intensive and complex queries in a DB2 for z/OS highly secure and available environment. DB2 and the Accelerator appliance form a self-managing hybrid environment running concurrently and efficiently online transaction processing and online transactional analytical processing together with business intelligence and online analytic processing workloads.

IBM DB2 Analytics Accelerator V4.1 expands the value of high-performance analytics. DB2 Analytics Accelerator 4.1 opens up to static SQL applications and row set processing, minimizes data movement, reduces latency, and improves availability.

In this IBM Redbooks® publication, we provide technical decision-makers with an understanding of the benefits of Version 4.1 of the Accelerator with DB2 11 for z/OS. We describe the installation of the new functions and the advantages to existing analytical processes as measured in our test environment. We also introduce the Analytics Accelerator Loader 1.1, a tool which facilitates the data population of the 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
23 July 2014

Planned Publish Date
31 August 2014

Rating: Not yet rated




IBM Form Number

Number of pages