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

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

by Adriana Melges Quintanilha Weingart, Speitim Velic, Yukiko Itaya, Dino Quintero
Released May 2015
Publisher(s): IBM Redbooks
ISBN: 9780738440675

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

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

  1. Front cover
  2. Notices
    1. Trademarks
  3. IBM Redbooks promotions
  4. Preface
    1. Authors
    2. Now you can become a published author, too!
    3. Comments welcome
    4. Stay connected to IBM Redbooks
  5. Chapter 1. Introducing SAP NetWeaver Business Warehouse with IBM DB2 BLU
    1. 1.1 Current challenges with analytic systems
    2. 1.2 Customer needs
    3. 1.3 IBM DB2 with BLU Acceleration
      1. 1.3.1 Lower operating costs
      2. 1.3.2 Extreme performance
      3. 1.3.3 Hardware optimization
    4. 1.4 DB2 BLU proof of concept (PoC) results
    5. 1.5 Archiving with NLS
    6. 1.6 Multi-temperature storage group
  6. Chapter 2. Requirements for an SAP NetWeaver BW environment
    1. 2.1 Introduction to SAP BW
    2. 2.2 DB2 with BLU Acceleration and SAP BWA
    3. 2.3 SAP Business Warehouse enhancements with DB2 10.5 Cancun Release (FP4)
    4. 2.4 System requirements and preparation
      1. 2.4.1 Software requirements
      2. 2.4.2 SAP DB2 10.5 bundle and SAP/IBM DB2 license
      3. 2.4.3 Restrictions for using BLU Acceleration
      4. 2.4.4 General sizing approach for DB2 BLU
      5. 2.4.5 Storage requirements
      6. 2.4.6 Platform requirements
  7. Chapter 3. Optimizing IBM Power Systems for SAP BW using IBM DB2 BLU
    1. 3.1 TurboCore mode of the IBM POWER7
    2. 3.2 Start the most important LPAR for memory affinity
    3. 3.3 Set DB2_RESOURCE_POLICY for memory affinity
    4. 3.4 Dedicated logical partition for stable performance
    5. 3.5 Active memory expansion is not recommended in this case
    6. 3.6 AIX tunables
    7. 3.7 Sizing approach with IBM Power Systems
  8. Chapter 4. SAP BW landscape scenario with IBM DB2 BLU Acceleration
    1. 4.1 Design SAP BW landscape
      1. 4.1.1 Hardware resources for SAP BW landscape with DB2 BLU
      2. 4.1.2 Considerations for the preproduction systems (DEV and QAS)
      3. 4.1.3 Consideration for the production system (PRD)
      4. 4.1.4 DB2 database layout for BLU
      5. 4.1.5 Migrate SAP BW to Power Systems with AIX
    2. 4.2 Implementation of SAP BW with DB2 BLU
      1. 4.2.1 Enabling adaptive row compression
      2. 4.2.2 Enabling automatic storage management during the installation
      3. 4.2.3 Enabling ASM after the SAP BW installation
      4. 4.2.4 Enabling intrapartition parallelism for BLU
      5. 4.2.5 DB2 Cancun parameter settings for BLU
      6. 4.2.6 SAP BW RSADMIN parameters for DB2 BLU Acceleration
      7. 4.2.7 Multi-temperature storage groups for DB2 temp table spaces
    3. 4.3 Administration and operation with SAP DB2 BLU
      1. 4.3.1 Transport system
      2. 4.3.2 Backup and restore
      3. 4.3.3 System copies
  9. Chapter 5. Adding IBM DB2 Near-Line Storage to archive cold temperature SAP BW data
    1. 5.1 NLS scenario for SAP BW landscape
      1. 5.1.1 Design for SAP NLS
      2. 5.1.2 Minimum resources for SAP NLS
      3. 5.1.3 Considerations for the preproduction systems (NDE and NQA)
      4. 5.1.4 Consideration for the production system (NPR)
    2. 5.2 Implementing the Near-Line Storage feature
      1. 5.2.1 Installation of the NLS database NDE
      2. 5.2.2 Configure the new database connection in the DBACockpit
      3. 5.2.3 Configure the NLS connection in SPRO
  10. Related publications
    1. IBM Redbooks
    2. Other publications
    3. Online resources
    4. Help from IBM
  11. Back cover

Product information

  • Title: Implementation Best Practices for IBM DB2 BLU Acceleration with SAP BW on IBM Power Systems
  • Author(s): Adriana Melges Quintanilha Weingart, Speitim Velic, Yukiko Itaya, Dino Quintero
  • Release date: May 2015
  • Publisher(s): IBM Redbooks
  • ISBN: 9780738440675