Skip to main content

Architecting and Deploying DB2 with BLU Acceleration

An IBM Redbooks publication

thumbnail 

Published on 14 October 2014, updated 14 March 2023

  1. .EPUB (8.8 MB)
  2. .PDF (10.6 MB)

Apple BooksGoogle Play Books

Share this page:   

ISBN-10: 0738440124
ISBN-13: 9780738440125
IBM Form #: SG24-8212-01


Authors: Whei-Jen Chen, Brigitte Blaser, Marco Bonezzi, Polly Lau, Jean Cristie Pacanaro, Martin Schlegel, Ayesha Zaka and Alexander Zietlow

    menu icon

    Abstract

    IBM® DB2® with BLU Acceleration is a revolutionary technology that is delivered in DB2 for Linux, UNIX, and Windows Release 10.5. BLU Acceleration delivers breakthrough performance improvements for analytic queries by using dynamic in-memory columnar technologies. Different from other vendor solutions, BLU Acceleration allows the unified computing of OLTP and analytics data inside a single database, therefore, removing barriers and accelerating results for users. With observed hundredfold improvement in query response time, BLU Acceleration provides a simple, fast, and easy-to-use solution for the needs of today's organizations; quick access to business answers can be used to gain a competitive edge, lower costs, and more.

    This IBM Redbooks® publication introduces the concepts of DB2 with BLU Acceleration. It discusses the steps to move from a relational database to using BLU Acceleration, optimizing BLU usage, and deploying BLU into existing analytic solutions today, with an example of IBM Cognos®.

    This book also describes integration of DB2 with BLU Acceleration into SAP Business Warehouse (SAP BW) and SAP's near-line storage solution on DB2. This publication is intended to be helpful to a wide-ranging audience, including those readers who want to understand the technologies and those who have planning, deployment, and support responsibilities.

    Table of Contents

    Chapter 1. Introducing DB2 BLU Acceleration

    Chapter 2. Planning and deployment of BLU Acceleration

    Chapter 3. Planning and deployment of BLU Acceleration shadow tables for mixed workload environments

    Chapter 4. Optim Query Workload Tuner and BLU Acceleration

    Chapter 5. Performance test with a Cognos BI example

    Chapter 6. Post-deployment of DB2 with BLU Acceleration

    Chapter 7. Oracle compatibility for BLU Acceleration

    Chapter 8. DB2 with BLU Acceleration and SAP integration

    Appendix A. BLU Acceleration monitor elements

     

    Others who read this also read