Building and scaling SAP business information warehouse on DB2 UDB ESE / [Chuck Ballard ... et al.].

Format:

Book

Contributor:

Ballard, Chuck.

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

DB2 information management software.

IBM redbooks

DB2 information management software

Language:

English

Subjects (All):

Data warehousing.

Management information systems.

Business enterprises--Computer networks.

Business enterprises.

SAP Business information warehouse.

IBM Database 2.

Physical Description:

xvi, 380 p. : ill.

Edition:

1st ed.

Place of Publication:

San Jose, CA : IBM, International Technical Support Organization, 2004.

Language Note:

English

Summary:

SAP is a leading ERP vendor, with a large install base. A key element in their product set is the SAP Business Information Warehouse (BW). The primary objective of this IBM Redbooks publication is to provide guidelines to help you implement your SAP Business Information Warehouse on DB2 UDB ESE. Two major considerations when building a business information warehouse are scalability and performance. In this book, we have demonstrated the wide range of scalability of BW when implemented on DB2, while maintaining the performance requirements that are so critical. The parallelism and data partitioning capabilities of DB2 Universal Database ESE, enables a robust, highly scalable, and high performance business information warehouse. For a common understanding, we first discuss the concepts of data warehousing and then describe the SAP architecture and robust component capabilities of the SAP business information warehouse. To help in your implementation, we provide guidelines for how to configure SAP BW when it is built on DB2. We also describe and discuss the key capabilities and parameters to help you get the best from DB2. Key topics such as sizing, partitioning, performance tuning, and systems administration, are discussed to assist in the implementation and maintenance of your system. This book will help enable you to more quickly and easily implement a robust SAP BW on DB2 UDB ESE.

Contents:

Front cover

Contents

Notices

Trademarks

Preface

The team that wrote this redbook

Become a published author

Comments welcome

Introduction

Management summary

Structure of the redbook

Chapter 1. SAP Business Information Warehouse (BW)

1.1 Data warehousing

1.1.1 Informational databases

1.1.2 Data warehousing

1.2 SAP BW positioning

1.3 SAP business solutions

1.4 SAP NetWeaver

1.5 SAP Business Intelligence and SAP BW

1.6 SAP BW customer scenario

1.7 Requirement for scalability

Chapter 2. SAP BW technical overview

2.1 SAP BW information model

2.2 Dataflow in SAP BW

2.3 Information access

2.4 Hierarchies

2.5 Extended star schema (InfoCubes)

2.6 Dataload into InfoCube

2.7 Aggregates

2.7.1 Aggregate example

2.7.2 Maintaining aggregates

2.8 Compression of requests

2.9 Operational data store (ODS)

2.10 The SAP BW functional components

2.11 SAP BW business content

Chapter 3. DB2 UDB ESE technical overview

3.1 The architecture

3.2 Functions and components

3.2.1 Database objects

3.2.2 Concurrency, locking and isolation levels

3.2.3 Parallel processing and partitioning

3.2.4 Cost-based optimizer

3.2.5 Join methods for distributed tables

3.2.6 Static and dynamic SQL statements

3.2.7 DB2 64-bit

3.3 DB2 monitoring and tuning tools

3.4 DB2 Version 8: a few highlights

3.4.1 Catalog caching

3.4.2 RUNSTATS enhancements

3.4.3 Multi-dimensional clustering

3.4.4 Concurrency features

3.4.5 High availability features

3.4.6 Connection concentrator

3.4.7 Merge statement

3.4.8 Multi-FixPak install for UNIX

Chapter 4. Building SAP BW on DB2

4.1 Value of building SAP BW on DB2 UDB ESE

4.1.1 Scalability

4.1.2 High performance

4.1.3 Ease of administration

4.2 Business advantage: the value proposition.

4.2.1 Low TCO

4.2.2 Reduced sizing risk and cost

4.3 SAP BW on DB2: value details

4.3.1 Architecture and features

4.3.2 Database layout

4.3.3 Parallel processing on multiple database partitions

4.3.4 Intra-partition parallelism

4.3.5 SAP BW query processing on DB2

4.3.6 Use of distribution statistics for query optimization

4.3.7 New features of the DBA Cockpit 6.40

Chapter 5. Project test environment

5.1 Hardware configuration

5.2 Software configuration

5.2.1 Operating system

5.2.2 Database management system

5.2.3 SAP Business Information Warehouse

5.2.4 Front-end software

5.3 Installation, scaling, and performance test scenarios

5.4 SAP BW sample application

Chapter 6. Implementing SAP BW on DB2

6.1 Sizing SAP BW on DB2

6.2 Implementation approaches

6.2.1 The Implementation Assistant

6.3 Preinstallation activities

6.3.1 Component considerations

6.4 Installation planning

6.4.1 The SAP Installation Notes

6.4.2 The installation checklists

6.4.3 System planning and preparation

6.5 Installation procedure

6.5.1 Installing the IBM DB2 Universal Database

6.5.2 Installing the Central Instance

6.5.3 Installing the SAP Database Instance

6.6 Post-installation activities

6.6.1 Additional post-installation activities

6.7 Business Information Warehouse definitions

6.7.1 BW general settings

6.7.2 Installing the SAP Business Content Add-on

6.7.3 Installing an additional Dialog Instance

6.8 HACMP for high availability

6.8.1 High availability and fault tolerance

6.8.2 HACMP clusters

Chapter 7. Administration of SAP BW

7.1 Role-based administration

7.2 DB2 UDB administration

7.3 Periodic activities

7.3.1 Storage management

7.3.2 Tablespace and container administration

7.3.3 The optimizer and runstats.

7.3.4 Tablespace reorganization

7.4 Backup and recovery

7.4.1 Defining a backup/recovery strategy and policy

7.4.2 Managing the DB2 UDB logfiles

7.4.3 Performing DB2 UDB backups

7.4.4 Database recovery

7.5 Authorization to administer SAP BW

7.6 Archiving SAP BW data

Chapter 8. SAP BW performance

8.1 The approach

8.2 Health check

8.2.1 SAP Notes related to performance and system configuration

8.2.2 How to keep DB2 database statistics current with SAP BW

8.2.3 How to control DB2 log space consumption with SAP BW

8.2.4 Recommended configuration parameters

8.3 Performance tuning

8.3.1 General SAP BW tuning

8.3.2 Tuning DB2 UDB ESE

8.4 Performance monitoring of SAP BW on DB2 UDB

8.4.1 Performance bottlenecks

8.4.2 Proactive monitoring

8.4.3 Problem analysis and resolution

Chapter 9. Scaling out the database

9.1 Options for installing and scaling the database

9.2 Scaling steps

9.2.1 Partitioning the database

9.2.2 Relocating database containers

9.2.3 Moving database partitions to another server

9.3 Summary

Chapter 10. Scalability factors of SAP BW on DB2 UDB ESE

10.1 DB2 scalability studies

10.2 Performance study for SAP BW on DB2 UDB EEE

10.2.1 Hardware environment

10.2.2 Scalability of single and multi-user SAP BW queries

10.2.3 Scalability of dataload from PSA into InfoCube

10.2.4 Summary of scalability test results

10.3 SAP Business Warehouse on DB2 UDB Sun Cluster

10.3.1 Hardware and software setup

10.3.2 Description of tests

10.3.3 Results of scalability tests

10.4 Performance of partitioned and unpartitioned database

Appendix A. SQL analysis with SAP BW

Glossary

Abbreviations and acronyms

Related publications

IBM Redbooks

Other publications

Online resources

How to get IBM Redbooks

Help from IBM

Index.

Back cover.

Notes:

"SG24-7094-00."

Includes bibliographical references and index.

OCLC:

80244437