Reliability and Performance with IBM DB2 Analytics Accelerator V4.1

An IBM Redbooks publication

Abstract

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

Chapter 1. The analytics lifecycle
Chapter 2. Database design considerations
Chapter 3. Overview of IBM DB2 Analytics Accelerator for z/OS V4.1
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
Chapter 9. Monitoring enhancements
Chapter 10. DB2 Analytics Accelerator Loader
Appendix A. Preparing input data for IBM DB2 Analytics Accelerator Loader




Profile

Publish Date
24 September 2014

Last Update
26 September 2014


Rating: Not yet rated


Author(s)

ISBN-10
0738439878

ISBN-13
9780738439877

IBM Form Number
SG24-8213-00

Number of pages
304