Skip to main content

Best Practices for SAP BI using DB2 9 for z/OS

An IBM Redbooks publication

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


Published on 17 March 2008, updated 31 March 2008

  1. .PDF (10.7 MB)

Share this page:   

ISBN-10: 0738485977
ISBN-13: 9780738485973
IBM Form #: SG24-6489-02

Authors: Mike Ebbers, Georg Mayer, Giovanni Grita, Martin Cardoso, Lindy Crawford, Wilfried Alle, Lydia Parziale and Theodor Kuebler

    menu icon


    Clients want to know how to exploit the new features of both DB2 V9 and SAP in their SAP BI environments. This IBM Redbooks publication describes the benefits of DB2 V9 for SAP Business Information Warehouse. It covers best practices and provides performance and tuning recommendations.

    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, DataSore 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.

    This book describes best practices for this product on a System z 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 z/OS environment is assumed.

    Table of Contents

    Chapter 1. Introduction

    Chapter 2. Overview of SAP BI and related data

    Chapter 3. Top ten SAP BI recommendations

    Chapter 4. Benefits of DB2 9 for SAP BI

    Chapter 5. Best practices for PSA

    Chapter 6. Best practices for InfoCubes

    Chapter 7. Best practices for DataStore

    Chapter 8. Query and Load performance

    Chapter 9. SAP BI Accelerator

    Chapter 10. Tips for SQL efficiency

    Chapter 11. Project Jupiter: large BI Accelerator scalability evaluation

    Chapter 12. Concepts, activities, and terminology

    Appendix A. Glossary for SAP BI

    Appendix B. SAP BI installation and checks under DB2 and z/OS

    Appendix C. SAP BW OSS Notes

    Appendix D. Project Jupiter: evaluation details


    Others who read this also read