Reliability and Performance with IBM DB2 Analytics Accelerator V4.1

An IBM Redbooks publication

Published 24 September 2014, updated 11 May 2015

cover image

ISBN-10: 0738439878
ISBN-13: 9780738439877
IBM Form #: SG24-8213-00
(304 pages)

More options

Rate and comment

Authors: Paolo Bruni, Jason Arnold, Leticia Cruz, Jeff Feinsmith, Willie Favero, Anna Griner, James Guo, Chris Harlander, Johannes Kern, Ravi Kumar, Ruiping Li, Andy Perkins, Jonathan Sloan, Steve Speller, Dino Tonelli

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

Follow IBM Redbooks

Follow IBM Redbooks