Data Federation with IBM DB2 Information Integrator V8.1

An IBM Redbooks publication

Published 16 October 2003

cover image

ISBN-10: 0738499161
ISBN-13: 9780738499161
IBM Form #: SG24-7052-00
(452 pages)

More options

Rate and comment

Authors: Paolo Bruni, Francis Arnaudies, Amanda Bennett, Susanne Englert, Gerhard Keplinger


Federation and integration are open technologies, which extend your investment on existing data and relational or non relational data by bringing it all together in a single virtual location for on demand application access. IBM DB2 Information Integrator V8.1 is the framework supporting federated data solutions.

This IBM Redbooks publication provides implementation guidelines for deploying a federated access solution with IBM DB2 Information Integrator V8.1. Topics include configuring, tuning, and debugging a federated system; use of federation in a business intelligence-like environment with read access to relational (DB2 family, Oracle, SQL Server) and non relational sources (flat files, XML, ODBC), and usage through queries or reporting tools.

This book will help you create a federated data solution with a case study, which accesses several data sources across the AIX , Windows , and z/OS platforms.

Table of contents

Part 1. Introduction
Chapter 1. Information integration concepts
Chapter 2. IBM DB2 Information Integrator V8.1
Part 2. Configuring the federated data solution
Chapter 3. The case study
Chapter 4. Configuring DB2 federated data support
Chapter 5. Installing and configuring DB2 Information Integrator
Part 3. Performance concepts with DB2 Information Integrator
Chapter 6. A performance tutorial
Chapter 7. Our performance tools
Part 4. Exploiting performance options
Chapter 8. National language support
Chapter 9. Nickname statistics
Chapter 10. Major server options with relational data sources
Chapter 11. Using data type mappings
Chapter 12. Using function mappings
Chapter 13. Major server options with non relational data sources
Chapter 14. Using index specifications
Chapter 15. Using materialized query tables
Part 5. Appendixes
Appendix A. Case study
Appendix B. Unicode tutorial

Others who read this publication also read

Follow IBM Redbooks

Follow IBM Redbooks