Book description
The IBM® DB2® Analytics Accelerator for IBM z/OS® is a high-performance appliance that integrates the IBM zEnterprise® infrastructure with IBM PureData™ for Analytics, powered by IBM Netezza® technology. With this integration, you can accelerate data-intensive and complex queries in a DB2 for z/OS highly secure and available environment.
DB2 and the Analytics Accelerator appliance form a self-managing hybrid environment running online transaction processing and online transactional analytical processing concurrently and efficiently. These online transactions run together with business intelligence and online analytic processing workloads.
DB2 Analytics Accelerator V4.1 expands the value of high-performance analytics. DB2 Analytics Accelerator V4.1 opens to static Structured Query Language (SQL) applications and row set processing, minimizes data movement, reduces latency, and improves availability.
This IBM Redbooks® publication provides technical decision-makers with an understanding of the benefits of version 4.1 of the Analytics Accelerator with DB2 11 for z/OS. It describes the installation of the new functions, and the advantages to existing analytical processes as measured in our test environment. This book also introduces the DB2 Analytics Accelerator Loader V1.1, a tool that facilitates the data population of the DB2 Analytics Accelerator.
Table of contents
- Front cover
- Tables
- Examples
- Figures
- Notices
- Preface
- Chapter 1. The analytics lifecycle
- Chapter 2. Database design considerations
-
Chapter 3. Overview of IBM DB2 Analytics Accelerator for z/OS V4.1
- 3.1 Introduction of DB2 Analytics Accelerator for z/OS V4.1
- 3.2 SQL enhancements
- 3.3 Workload management
- 3.4 Incremental update
- 3.5 High Performance Storage Saver enhancements
- 3.6 Monitoring (new counters including incremental update)
- 3.7 Installation, operations, and maintenance
- 3.8 Updates in DB2 Analytics Accelerator V4.1 PTF-2
- 3.9 Updates in DB2 Analytics Accelerator V4.1 PTF-3
- 3.10 DB2 Analytics Accelerator tools
- 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 workload balancing
- 8.1 High availability of DB2 Analytics Accelerators
- 8.2 Disaster recovery of DB2 Analytics Accelerator
- 8.3 Environment
- 8.4 Basic DB2 Analytics Accelerator workload balancing
- 8.5 High availability behavior with workload balancing
- 8.6 Built-in HA DB2 Analytics Accelerator host server
- 8.7 Remote DB2 Analytics Accelerator experiments
- Chapter 9. Monitoring enhancements
- Chapter 10. DB2 Analytics Accelerator Loader
- Appendix A. Preparing input data for IBM DB2 Analytics Accelerator Loader
- Related publications
- Back cover
-
IBM System x Reference Architecture for Hadoop: IBM InfoSphere BigInsights Reference Architecture
- Introduction
- Business problem and business value
- Reference architecture use
- Requirements
- InfoSphere BigInsights predefined configuration
- InfoSphere BigInsights HBase predefined configuration
- Deployment considerations
- Customizing the predefined configurations
- Predefined configuration bill of materials
- References
- The team who wrote this paper
- Now you can become a published author, too!
- Stay connected to IBM Redbooks
- Notices
Product information
- Title: Reliability and Performance with IBM DB2 Analytics Accelerator V4.1
- Author(s):
- Release date: September 2014
- Publisher(s): IBM Redbooks
- ISBN: None
You might also like
book
Applied Statistics and Probability for Engineers, 5th Edition
Montgomery and Runger's best-selling engineering statistics text provides a practical approach oriented to engineering as well …
book
The Trade Lifecycle: Behind the Scenes of the Trading Process, 2nd Edition
Drive profit and manage risk with expert guidance on trade processing The Trade Lifecycle catalogues and …
book
Analysis of Financial Time Series, Third Edition
This book provides a broad, mature, and systematic introduction to current financial econometric models and their …
book
Applied Statistics and Probability for Engineers, 6th Edition
This best-selling engineering statistics text provides a practical approach that is more oriented to engineering and …