Book description
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
- Front cover
- Figures
- Tables
- Examples
- Notices
- Preface
- 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
- 5.1 Query acceleration processing flow
- 5.2 Query acceleration settings and enablement
- 5.3 Query acceleration criteria
- 5.4 How IBM DB2 Analytics Accelerator handles correlated subqueries
- 5.5 INSERT from subselect query acceleration processing
- 5.6 Profile tables
- 5.7 Accelerator EXPLAIN support
- 5.8 DB2 Analytics Accelerator hardware considerations
- Chapter 6. High-Performance Storage Saver
-
Chapter 7. Incremental update
- 7.1 Overview of incremental update
- 7.2 Incremental update architecture
- 7.3 Installation and configuration
- 7.4 Defining incremental update between a DB2 subsystem and the Accelerator
- 7.5 Defining tables to incremental update
- 7.6 Access server
- 7.7 z/OS capture agent
- 7.8 Accelerator target agent
- 7.9 Incremental update scenarios
- 7.10 Summary
- 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
- Related publications
- Back cover
Product information
- Title: Hybrid Analytics Solution using IBM DB2 Analytics Accelerator for z/OS V3.1
- Author(s):
- Release date: September 2013
- Publisher(s): IBM Redbooks
- ISBN: 9780738438795
You might also like
book
Understanding Augmented Reality
Understanding Augmented Reality addresses the elements that are required to create augmented reality experiences. The technology …
book
Mastering Distributed Tracing
Understand how to apply distributed tracing to microservices-based architectures Key Features A thorough conceptual introduction to …
video
Introduction to Docker and the DCA Certification
A comprehensive introduction to Docker with a heavy focus on labs About This Video Images: Templates …
book
SAP® ERP Financials and FICO Handbook
This up-to-date quick reference guides the reader through the most popular SAP module. It includes material …