Hybrid Analytics Solution using IBM DB2 Analytics Accelerator for z/OS V3.1

An IBM Redbooks publication

Published 27 September 2013

Authors: Paolo Bruni, Willie Favero, James Guo, Ravikumar Kalyanasundaram, Ruiping Li, Cristian Molaro, Andy Perkins, Theresa Tai, Dino Tonelli


The IBM® DB2® Analytics Accelerator Version 3.1 for IBM z/OS® (simply called Accelerator in this book) is a union of the IBM System z® quality of service and IBM Netezza® technology to accelerate complex queries in a DB2 for z/OS highly secure and available environment. Superior performance and scalability with rapid appliance deployment provide an ideal solution for complex analysis.

In this IBM Redbooks® publication, we provide technical decision-makers with a broad understanding of the benefits of Version 3.1 of the Accelerator's major new functions. We describe their installation and the advantages to existing analytical processes as measured in our test environment. We also describe the IBM zEnterprise® Analytics System 9700, a hybrid System z solution offering that is surrounded by a complete set of optional packs to enable customers to custom tailor the system to their unique needs..

Table of contents

Chapter 1. The analytics lifecycle
Chapter 2. Using the Studio client to manage the environment
Chapter 3. Data latency management
Chapter 4. Accelerator resource management
Chapter 5. Query acceleration management
Chapter 6. High-Performance Storage Saver
Chapter 7. Incremental update
Chapter 8. Impact of new Netezza hardware and software components
Chapter 9. Monitoring DB2 Analytics Accelerator environments
Chapter 10. IBM zEnterprise Analytics System 9700
Chapter 11. High availability considerations
Appendix A. Accelerated queries
Appendix B. Notes on maintenance
Appendix C. DSNZPARM parameters setting for data warehouse
Appendix D. Tools for Accelerator
Appendix E. Additional material

Follow IBM Redbooks

Follow IBM Redbooks