Skip to main content

Implementation Best Practices for IBM DB2 BLU Acceleration with SAP BW on IBM Power Systems

An IBM Redbooks publication

thumbnail 

Published on 11 May 2015

  1. .EPUB (1.4 MB)
  2. .PDF (2.4 MB)

Apple BooksGoogle Play Books

Share this page:   

ISBN-10: 0738440671
ISBN-13: 9780738440675
IBM Form #: SG24-8258-00


Authors: Dino Quintero, Yukiko Itaya, Speitim Velic and Adriana Melges Quintanilha Weingart

    menu icon

    Abstract

    BLU Acceleration is a new technology that has been developed by IBM® and integrated directly into the IBM DB2® engine. BLU Acceleration is a new storage engine along with integrated run time (directly into the core DB2 engine) to support the storage and analysis of column-organized tables. The BLU Acceleration processing is parallel to the regular, row-based table processing found in the DB2 engine. This is not a bolt-on technology nor is it a separate analytic engine that sits outside of DB2. Much like when IBM added XML data as a first class object within the database along with all the storage and processing enhancements that came with XML, now IBM has added column-organized tables directly into the storage and processing engine of DB2.

    This IBM Redbooks® publication shows examples on an IBM Power Systems™ entry server as a starter configuration for small organizations, and build larger configurations with IBM Power Systems larger servers. This publication takes you through how to build a BLU Acceleration solution on IBM POWER® having SAP Landscape integrated to it.

    This publication implements SAP NetWeaver Business Warehouse Systems as part of the scenario using another DB2 Feature called Near-Line Storage (NLS), on IBM POWER virtualization features to develop and document best recommendation scenarios.

    This publication is targeted towards technical professionals (DBAs, data architects, consultants, technical support staff, and IT specialists) responsible for delivering cost-effective data management solutions to provide the best system configuration for their clients' data analytics on Power Systems.

    Table of Contents

    Chapter 1. Introducing SAP NetWeaver Business Warehouse with IBM DB2 BLU

    Chapter 2. Requirements for an SAP NetWeaver BW environment

    Chapter 3. Optimizing IBM Power Systems for SAP BW using IBM DB2 BLU

    Chapter 4. SAP BW landscape scenario with IBM DB2 BLU Acceleration

    Chapter 5. Adding IBM DB2 Near-Line Storage to archive cold temperature SAP BW data

     

    Others who read this also read