Mike Ebbers
50 TB Data Warehouse
Benchmark on IBM
System z
Why use System z and IBM storage for
Data Warehousing
Tips for building a very large
database
Reporting and analysis with
Cognos
Mike Ebbers
Nin Lei
Manoj Agrawal
M. Leticia Cruz
Willie Favero
Juraj Hrapko
Shantan Kethireddy
Cristian Molaro
Frank Neumann
PS Prem
ibm.com/redbooksInternational Technical Support Organization
50 TB Data Warehouse Benchmark on IBM System z
May 2009
SG24-7674-00Note: Before using this information and the product it supports, read the information in “Notices” on
page xvii.
First Edition (May 2009)
This edition applies to Version 1 Release 9 of z/OS and Version 9 of DB2.
© Copyright International Business Machines Corporation 2009. All rights reserved.
Note to U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP Schedule
Contract with IBM Corp.Contents
Figures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix
Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xv
Notices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii
Trademarks . . . . . . . . . . ...