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

An IBM Redbooks publication


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


Publish Date
28 February 2002

Last Update
12 March 2002

Rating: Not yet rated




IBM Form Number

Number of pages