Data Warehousing With DB2 Family for IBM System z Customers

Data Warehousing with the DB2 Family for System z
Customers Leveraging Platform Strengths
December 31, 2008 Authors: Gary Crupi, Executive IT Specialist, IBM Jonathan Sloan, Executive IT Specialist, IBM Jay Allen, Consulting IT Specialist, IBM Audience: Chief Information Officers Chief Technology Officers Chief Architects Directors of Enterprise Infrastructure Business Intelligence and Data Warehouse Solution Architects Business Analysts Database Administrators Data Warehousing with the DB2 Family for System z Customers Leveraging Platform Strengths
Executive Summary............................................................................................................... 3 Historically Common Solution Approaches to Data Warehousing ................................... 7 Scalability .......................................................................................................................... 8 Matching Requirements to Platform Strengths...................................................................... 9 Data Warehousing with DB2 for z/OS on System z10...................................................... 9 IBM InfoSphere Balanced Warehouse E-Class on System p ............................................ 9 IBM InfoSphere Balanced Warehouse C-Class and D-Class on System x ....................... 9 IBM DB2 for Linux on System z with the Data Partitioning Feature ............................. 10 Factors to Consider for Platform Choices............................................................................ 10 Availability ...................................................................................................................... 10 Disaster Recovery ............................................................................................................ 12 Mixed Workloads and Workload Management............................................................... 12 Real-Time Operational Data Store................................................................................... 13 Incremental Growth ......................................................................................................... 13 Market Hardened Solution............................................................................................... 14 Low Risk / Prescriptive Implementation ......................................................................... 14 Desirable Total Costs....................................................................................................... 14 Financial Implications of Trade-In Value........................................................................ 15 Performance Implications of Collocation ........................................................................ 15 Making Warehouse Workloads More Operational in Nature.......................................... 16 Customer Examples ............................................................................................................. 17 Mainframe Solution - Data Warehousing with DB2 for z/OS on System z ................... 17 Hybrid Solution - Data Warehousing with DB2 for z/OS and InfoSphere Balanced Warehouse on System p................................................................................................... 17 Distributed Solution - InfoSphere Balanced Warehouse on System p............................ 17 Closing Thoughts................................................................................................................. 18 About the Authors................................................................................................................ 19
2Data Warehousing with the DB2 Family for System z Customers Leveraging Platform Strengths
Executive Summary As businesses evolve to take advantage of new market opportunities, they are driving changes throughout information technology, and that includes driving investments in data warehousing and business intelligence initiatives. IBM has responded to these new demands with business intelligence solutions based on System z® and with more investment in the development and evolution of System z alternatives that complement existing System xT and System p® offerings. The IBM DB2® family of data servers play an important role in past, present and future demands because of their industry-leading performance, security, availability and scalability - and because they can cap... [download for more]