Building and Scaling SAP Business Information Warehouse on DB2 UDB ESE

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 Redbook 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 redbook will help enable you to more quickly and easily implement a robust SAP BW on DB2 UDB ESE.

Chapter 1. SAP Business Information Warehouse (BW)
Chapter 2. SAP BW technical overview
Chapter 3. DB2 UDB ESE technical overview
Chapter 4. Building SAP BW on DB2
Chapter 5. Project test environment
Chapter 6. Implementing SAP BW on DB2
Chapter 7. Administration of SAP BW
Chapter 8. SAP BW performance
Chapter 9. Scaling out the database
Chapter 10. Scalability factors of SAP BW on DB2 UDB ESE
Appendix A. SQL analysis with SAP BW

• TCP/IP Tutorial and Technical Overview, GG24-3376-07
• Best Practices for SAP BI using DB2 9 for z/OS, SG24-6489-02
• IBM PowerVM Virtualization Managing and Monitoring, SG24-7590-01

Publish Date
29 June 2004

Last Update
29 October 2004

Rating:
(based on 5 reviews)

Rate this book

Author(s)

Chuck Ballard is a Project Leader at the International Technical Support Organization, in San Jose, California. He has over 35 years experience, holding positions in the areas of Product Engineering, Sales, Marketing, Technical Support, and Management. His expertise is primarily in the areas of database, data management, data warehousing, business intelligence, and process re-engineering. He has written extensively on these subjects, taught classes, and presented at conferences and seminars worldwide. Chuck has both a Bachelors degree and a Masters degree in Industrial Engineering from Purdue University.

• Chuck Ballard

Andreas Christian works at the SAP DB2 UDB Development / Porting Center in Walldorf Germany. He provides technical support, consultancy, and knowledge transfer, in the area of SAP BW/DB2 UDB for customers, consultants, IBM partners, and IBM marketing and pre-sales. He started to work for IBM in 1999 as a member of the IBM SAP BW/DB2 UDB porting team. In addition to his development activities, he has performed many SAP BW/DB2 UDB installations and upgrades, and helped customers to migrate their SAP BW systems to DB2 UDB ESE. In 2002, he investigated DB2 scalability with SAP BW. The results of this study validate DB2's unique scalability across multiple database servers and were published through IBM/SAP.

• Andreas Christian

Theodor H. Kuebler is a consultant and trainer for SAP and Data Management products. He is founder of the Logos Informations Syteme (LIS) AG in Switzerland (www.lis-ag.ch), an IBM enabled Education Center for IBM Software (ECIS), and an IBM Business Partner, providing classroom and onsite courses in Data Management, Tivoli, and WebSphere. He has 12 years experience in implementation and tuning of SAP products on database management systems, such as DB2 UDB, Adabas-D, and Oracle, and on different platforms. He teaches SAP Basis courses for Z/OS and DB2, worldwide.

• Theodor H. Kuebler

Rodrigo A. Schiavon is an SAP consultant and works in the outsourcing area at IBM Brazil, with 6 years experience in implementation and tuning of SAP products. He is an SAP certified consultant in R/3 and BW systems.

• Rodrigo A. Schiavon

ISBN

0738490253

IBM Form Number
SG24-7094-00

Number of pages
396