Skip to main content

Best Practices for SAP Business Information Warehouse on DB2 UDB for z/OS V8

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.


Published on 30 April 2008

  1. .PDF (4.1 MB)

Share this page:   

ISBN-10: 0738492337
ISBN-13: 9780738492339
IBM Form #: SG24-7644-00

Authors: Mike Ebbers, Brenda Beane, David Bellion, Nick Dyke, Andrew Hartman, Veng Ly, Mike Mardis, Bala Prabahar, Michael Thelosen and Theodor H. Kuebler

    menu icon


    Note: This is a republishing of SG24-6489-00, which was withdrawn in error when we updated it with SG24-6489-01. This -00 book covers DB2 V8 while the -01 version covers DB2 V9, so we are making both books available.

    This IBM Redbooks publication describes the benefits of DB2® V8 for SAP Business Information Warehouse. It lists best practices and provides performance and tuning recommendations for SAP Business Information Warehouse.

    In today’s fast-moving business environment, there is a need for more and better business information. Data warehousing and business intelligence (BI) systems deliver that information. This imposes new requirements to manage, control, and use this data for business purposes.

    SAP Business Information Warehouse is the central reporting tool for almost all SAP business solutions. It is based on building blocks called InfoObjects that contain data about customers, sales, and business information. InfoObjects include InfoSources, ODS objects, and InfoCubes. The business intelligence solution from IBM and SAP can help you aggregate and leverage this information, giving you a system-wide view of your business data and delivering it across your enterprise to support sound business decisions.

    However, this structure can lead to slow performance if the system is not set up and managed according to good database principles. This book describes best practices for this product on a zSeries® platform, and provides performance and tuning recommendations for loading and querying data. It also addresses general system administration and troubleshooting.

    The audience for this book includes SAP and DB2 administrators. Knowledge of these products and of the WhitepaperRedpaper z/OS® environment is assumed.

    This book is designed to aid the reader based on specific needs. After describing the product and summarizing its advantages on the zSeries platform, we list best practices for the PSA, Infocube, ODS, and DB2 components. We give tips on how to gain efficiency when using compression and indexing. We also include a troubleshooting chapter that describes what to do when best practices do not address a problem.

    Table of Contents

    Chapter 1. Introduction

    Chapter 2. Top ten SAP BW recommendations

    Chapter 3. Best practices for PSA

    Chapter 4. Best practices for InfoCubes

    Chapter 5. Best practices for Operational Data Store

    Chapter 6. Tips for SQL efficiency

    Chapter 7. Troubleshooting poor performance

    Chapter 8. SAP BW installation and checks under z/OS

    Chapter 9. DB2

    Chapter 10. Concepts, activities, and terminology

    Chapter 11. Benefits of DB2 V8 and the zSeries platform

    Appendix A. SAP BW 3.5 OSS Notes

    Appendix B. Glossary for SAP BW from September 2004


    Others who read this also read