Skip to main content

Capacity Planning for Business Intelligence Applications: Approaches and Methodologies

An IBM Redbooks publication

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


Published on 15 November 2000, updated 13 December 2000

  1. .PDF (2.4 MB)

Share this page:   

ISBN-10: 0738418994
ISBN-13: 9780738418995
IBM Form #: SG24-5689-00

Authors: Seungrahn Hahn, M.H. Ann Jackson, Bruce Kabath, Ashraf Kamel, Caryn Meyers, Ana Rivera Matias, Merrilee Osterhoudt and Gary Robinson

    menu icon


    Businesses of all sizes are recognizing the powerful effect that data analysis can have on decision-making, resulting in the increasing deployment of Business Intelligence (BI) applications and solutions. This IBM Redbooks publication contains approaches and methodologies that help you do capacity planning for the system resources that support BI applications accessing DB2 on OS/390.

    Written for S/390 capacity planners, it includes the following:

    A discussion of the fundamental concepts of BI environments

    A structured methodology for doing a capacity plan for the S/390 BI hardware and software infrastructure

    A detailed description of how experienced capacity planners can modify traditional S/390 capacity planning techniques to address the unique characteristics of BI environments

    A set of worksheets to help you and your team members develop a S/390 BI infrastructure capacity plan

    This book addresses capacity planning for the S/390 Business Intelligence infrastructure, which includes processors, memory, I/O subsystems and DASD; it does not address capacity planning of network or non-S/390 hardware platforms.

    Table of Contents

    Chapter 1. Introduction to capacity planning

    Chapter 2. Resource usage attributes of a query workload

    Chapter 3. Data maintenance

    Chapter 4. Characterization of existing workloads

    Chapter 5. Establishing current system usage

    Chapter 6. Growing existing workloads

    Chapter 7. Sizing methodologies for new applications

    Chapter 8. Estimating model size for IBM DB2 OLAP Server

    Chapter 9. Sizing IM for Data for performance

    Appendix A. Sample worksheets

    Appendix B. Data models

    Appendix C. Data Propagator Relational( DPropR)

    Appendix D. Capture ratios


    Others who read this also read