e-Business Intelligence: Data Mart Solutions with DB2 for Linux on zSeries

An IBM Redbooks publication

Published 28 February 2002, updated 12 March 2002

cover image

ISBN-10: 0738423890
ISBN-13: 9780738423890
IBM Form #: SG24-6294-00
(164 pages)

Authors: Viviane Anavi-Chaput

Abstract

This IBM Redbooks publication explains the benefits of Business Intelligence solutions using DB2 for Linux on zSeries. We discuss several studies done at IBM zSeries Teraplex Integration Center to demonstrate how the latest features of the zSeries hardware and z/VM 4.2 operating environment extend the value proposition for consolidating data marts on DB2 for Linux for zSeries.
The book describes fast data transfer using HiperSocket connections, investigates scalability and performance issues in the context of data mart population, data mart refresh, data mart joins, intelligent resource management of zSeries under z/VM, and application deployment. We evaluate DB2 V7 latest utilities and DB2 federated database distributed queries.
The book also includes functional tests of OLAP tools such as Dimensional Insight.

Table of contents

Chapter 1. Introducing BI solutions using Linux on zSeries
Chapter 2. Test environment infrastructure
Chapter 3. Test scenarios and measurement methodology
Chapter 4. Data population
Chapter 5. Data refresh
Chapter 6. Distributed data mart access
Chapter 7. z/VM resource allocation across Linux guests
Chapter 8. BI solutions for Linux on zSeries
Appendix A. Linux guests on z/VM
Appendix B. DB2 for Linux scripts to create the data mart
Appendix C. Networking definitions
Appendix D. Federated database setup
Appendix E. Data population scripts
Appendix F. Data refresh scripts
Appendix G. Distributed request scripts
Appendix H. Dimensional Insight - Atlantis Installation

Follow IBM Redbooks

Follow IBM Redbooks