Skip to main content

50 TB Data Warehouse Benchmark on IBM System z

An IBM Redbooks publication

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


Published on 27 May 2009

  1. .PDF (6.5 MB)

Share this page:   

ISBN-10: 0738432741
ISBN-13: 9780738432748
IBM Form #: SG24-7674-00

Authors: Mike Ebbers, Nin Lei, Manoj Agrawal, M. Leticia Cruz, Willie Favero, Juraj Hrapko, Shantan Kethireddy, Cristian Molaro, Frank Neumann and PS Prem

    menu icon


    Customers have a strong interest in the scalability of data warehousing solutions on the IBM System z platform using DB2 for z/OS. Because BI environments continue to grow, this IBM Redbooks publication explores the scaling and management of data in sizes beyond 50 TB. We explore the architectural software components that enable us to manage a data warehouse of this magnitude, including the Cognos product set.

    The objective of our 50 TB study was to test System z scalability in a BI environment and to develop the best practices of managing large data warehouses. The IBM System z was proven to scale to larger volumes, manage a mixed workload, lower the cost of a BI solution using zIIPs, and increase performance by using hardware compression.

    Table of Contents

    Chapter 1. Introduction

    Chapter 2. Data warehousing overview

    Chapter 3. Why System z and IBM storage for Data Warehousing

    Chapter 4. Configuration

    Chapter 5. VLDB build tips and pointers

    Chapter 6. Balancing a data warehouse

    Chapter 7. Data and index compression

    Chapter 8. Reporting and analysis with Cognos

    Chapter 9. Scalability

    Chapter 10. Using materialized query tables

    Chapter 11. Workload management

    Chapter 12. Extract, transform, and load

    Chapter 13. Summary: observations and conclusions


    Others who read this also read