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
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
DB2 Recovery Expert for Multiplatforms
DB2 Recovery Expert is one of the most recent IBM Data Management Tools for Multiplatforms. It …
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
SQL Procedures, Triggers, and Functions on IBM DB2 for i
Structured Query Language (SQL) procedures, triggers, and functions, which are also known as user-defined functions (UDFs), …