The IBM® DB2® Analytics Accelerator Version 2.1 for IBM z/OS® (also called DB2 Analytics Accelerator or Query Accelerator in this book and in DB2 for z/OS documentation) is a marriage of the IBM System z® Quality of Service and 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.

This IBM Redbooks® publication provides technical decision-makers with a broad understanding of the IBM DB2 Analytics Accelerator architecture and its exploitation by documenting the steps for the installation of this solution in an existing DB2 10 for z/OS environment.

In this book we define a business analytics scenario, evaluate the potential benefits of the DB2 Analytics Accelerator appliance, describe the installation and integration steps with the DB2 environment, evaluate performance, and show the advantages to existing business intelligence processes.

Part 1. Business analytics with DB2 for z/OS

Chapter 1. Data warehousing on System z

Chapter 2. The DB2 for z/OS integrated solution

Part 2. Sample DB2 Analytics Accelerator implementation

Chapter 3. The business scenario

Chapter 4. Feasibility study

Chapter 5. Installation and configuration

Chapter 6. Workload Manager settings for DB2 Analytics Accelerator

Chapter 7. Monitoring DB2 Analytics Accelerator environments

Chapter 8. Operational considerations

Chapter 9. Using Studio client to define and load data

Chapter 10. Query acceleration management

Chapter 11. Latency management

Chapter 12. Performance considerations

Chapter 13. Security considerations

Part 3. Additional topics

Chapter 14. Analytics and reporting on System z

Chapter 15. Data sharing and disaster recovery

Appendix A. Recommended maintenance

Appendix B. Additional material