Skip to main content

Reliability and Performance with IBM DB2 Analytics Accelerator V4.1

An IBM Redbooks publication

thumbnail 

Published on 24 September 2014, updated 11 May 2015

  1. .EPUB (5.4 MB)
  2. .PDF (8.1 MB)

Apple BooksGoogle Play Books

Share this page:   

ISBN-10: 0738439878
ISBN-13: 9780738439877
IBM Form #: SG24-8213-00


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 and Dino Tonelli

    menu icon

    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

     

    Others who read this also read