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
Enabling Real-time Analytics on IBM z Systems Platform
Regarding online transaction processing (OLTP) workloads, IBM® z Systems™ platform, with IBM DB2®, data sharing, Workload …
book
Smarter Business: Dynamic Information with IBM InfoSphere Data Replication CDC
To make better informed business decisions, better serve clients, and increase operational efficiencies, you must be …
book
IBM Db2: Investigating Automatic Storage Table Spaces and Data Skew
The scope of this IBM® Redpaper™ publication is to provide a high-level overview of automatic storage …
book
Understanding and Using Q Replication for High Availability Solutions on the IBM z/OS Platform
With ever-increasing workloads on production systems from transaction, batch, online query and reporting applications, the challenges …