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.

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