IBM DB2 for Linux, UNIX and Windows offers unique features like 'Multidimensional Clustering' (MDC) and 'Database Partitioning' (DPF) for data warehouse/OLAP-like workloads. Read on to find out how these features are used by SAP NetWeaver Business Warehoouse.
These documents describes the physical database layout, the administration tasks that you have to perform and performance recommendations for an SAP NetWeaver Business Warehouse 7.0 system and higher on IBM DB2 for Linux, UNIX, or Windows. The updated administration guide now contains the description of how to use the MDC Advisor. As of SAP EHP1 for SAP Netweaver 7.0, you can use the MDC Advisor (now part fo the DBA Cockpit) to collect and analyze SAP BI reporting queries for an InfoProvider. The MDC Advisor returns an MDC proposal for the fact tables of an InfoCube and for the active table of a DataStore object. Based on this MDC proposal, you can change the clustering of the analyzed InfoProvider
This paper provides an introduction to Multidimensional clustering (MDC) which is a unique feature of IBM DB2 for Linux, UNIX and Windows.
The primary objective of this IBM Redbook is to demonstrate and document the process of Installing, Administering, Tuning and Scaling SAP Business Information Warehouse with DB2 Universal Database (UDB) Enterprise Server Edition (ESE). Another important goal of this book is to familiarize you with the architecture and functionality of SAP BW and DB2 UDB ESE.
More on SAP Netweaver BW With IBM DB2 for LUW
This article provides an overview of the optimizations for SAP Retail and SAP NetWeaver BW regarding efficient data management and processing of large Point of Sales (POS) data volumes on the parallel database IBM DB2 for Linux, UNIX, and Windows (in the following referred to as DB2 for LUW) on IBM POWER7 servers.
The DB2 Design Advisor is a tool that you can use to find suitable Multidimensional Clustering (MDC) dimensions. This document describes how you can do so in the SAP NetWeaver BW environment.
Multidimensional Clustering (MDC) is a feature of DB2 for Linux, UNIX, and Windows. This feature is designed for OLAP systems and has been integrated in the SAP NetWeaver BW environment. This document provides answers to frequently asked questions about MDC.
SAP NetWeaver 7.02: Enabling an SAP NetWeaver BW to Use IBM DB2 for Linux, UNIX, and Windows as Near-Line Storage SMP (login required)
SAP NetWeaver 7.30: Enabling an SAP NetWeaver BW to Use IBM DB2 for Linux, UNIX, and Windows as Near-Line Storage SMP (login required)
Near-Line Storage is a new category of data persistency that is similar to archiving. The overall goal of a near-line storage solution is to take read-only data out of the SAP NetWeaver Business Warehouse system without loosing the ability to access the data directly for analysis and ETL purposes. This means, the database size of your SAP NetWeaver BW system reduces, the overall system performance improves and you still have read access to the data in the NLS database. This document describes the steps to perform to install a IBM DB2 for LUW database as near-line storage repository and how to attach it to your current SAP NetWeaver Business Warehouse system. It also describes briefly the most common operations in a system with a near-line storage solution.
This paper provides guidelines and recommendations for running SAP NetWeaver BW on IBM InfoSphere Warehouse.u00A0 It provides hardware sizing recommendations, discusses the IBM DB2 for Linux, UNIX and Windows features exploited in SAP NetWeaver BW, proposes an optimal DB2 LUW DPF database layout and data distribution and summarizes DB2 configuration parameter settings for SAP NetWeaver BW.
Multi-dimensional clustering (MDC) is a unique feature of IBM DB2 for Linux, UNIX and Windows (DB2 for LUW) that allows physically clustering the data in a table along multiple dimensions. This feature is especially beneficial for query performance in business intelligence applications that use star and snowflake schemas and process large amounts of data with restrictions on several dimensions. MDC has been integrated in SAP NetWeaver Business Intelligence (BI) applications.
This document describes the details of the migration procedure for an SAP NetWeaver BW system to IBM for Linuxu, UNIX and Windows as target database platform. It covers the following SAP system releases: SAP Business Information Warehouse 3.0B and 3.1 Content, SAP NetWeaver BW '04, SAP NetWeaver BW 7.0 including available Enhancement Packages.
This document describes an IBM DB2 Proof of Concept which was performed from July to October 2007 for a European customer with SAP NetWeaver Business Warehouse. The project started with a DB2 compression assessment on HP Itanium hardware which was the hardware platform in use by the customer. It was then further extended by a performance benchmark on IBM System p hardware.
This IBM Redbooks publication describes the testing that was done in terms of performance and manageability in a SAP NetWeaver BI (SAP BW) and DB2 environment on IBM System pwhen scaling a client's solution to a data warehouse of 20 terabytes (TB). It also provides recommendations for an architecture to support a potential 60 TB data warehouse.
This IBM Whitepaper examines the storage savings and the performance impact of row compression in a data warehouse environment. Measurements were done based on a data schema provided by the TPC-H benchmark. Best Practices for row compression through DB2 REORG are discussed.
Part 1 of a series of three whitepapers documenting a Proof of Concept for SAP NetWeaver BI at 20 Terabytes based on actual business requirements done by IBM and SAP for a large international consumer goods enterprise.
This document describes the usage of DB2 Storage Optimization Feature in a large Proof of Concept to validate manageability and scalability of a 20 Terabyte SAP NetWeaver 2004 BI (BI Version 3.5) installation running on DB2 using the database partitioning feature with 33 partitions.
This document describes the usage of DB2 Performance Expert as a central monitoring utility in a large Proof of Concept to validate Manageability and Scalability of a 20 Terabyte SAP BI installations running on DB2 using the database partitioning feature with 33 partitions.