Capacity Planning for Business Intelligence Applications: Approaches and Methodologies

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 Redbook 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 redbook 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.

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

Publish Date
15 November 2000

Last Update
13 December 2000

Rating:
(based on 3 reviews)

Rate this book

Author(s)
Seungrahn Hahn
M.H. Ann Jackson
Bruce Kabath
Ashraf Kamel
Caryn Meyers
Ana Rivera Matias
Merrilee Osterhoudt
Gary Robinson

ISBN
0738418994

IBM Form Number
SG24-5689-00

Number of pages
208