1. Home
  2. Certification
  3. Advanced DBA Certification Guide and Reference

Summary

With a federated system you can send distributed requests to multiple data sources within a single SQL statement. The power of a DB2 federated system is in its ability to:

  • Join data from local tables and remote data sources, as if all the data are local.

  • Take advantage of the data source processing strengths by sending distributed requests to the data sources for processing.

  • Compensate for SQL limitations at the data source by processing parts of a distributed request at the federated server.



    		IBM Press Series?Information Management
    		About Prentice Hall Professional Technical Reference
    		Foreword
    		Preface
    		Chapter 1. Data Storage
    		Chapter 2. Data Manipulation
    		Chapter 3. Database Availability
    		Chapter 4. Database Security
    		Chapter 5. Multi-Dimensional Clustering
    		Chapter 6. The DB2 Optimizer
    		Chapter 7. Federated Database Access
    		What Is a Federated System?
    		Overview of the Tasks to Set Up a Federated System
    		How Do You Interact with a Federated System?
    		Setting Up the Federated Server and Database
    		Working with the Federated Data
    		Sample Configuration Federated between DB2 on OS/390 and DB2 on Sun Solaris
    		Configuration of a Federated Database System
    		Nickname Characteristics Affecting Global Optimization
    		Summary
    		Chapter 8. Performance Tuning
    		Chapter 9. Database Communications
    		Chapter 10. Performance Tuning Examples
    		Appendix A. Useful DB2 Commands
    		Appendix B. parseSQL.pl
    		Appendix C. exfmtDIF.pl
    		Appendix D. Comparing Index Advisor Recommended Indexes with Existing Indexes
    		Appendix E. Configuration Parameters That Can Be Changed Online
    		Appendix F. Explain Tools
    		Appendix G. Starting and Stopping a DB2 Instance
    		Appendix H. LDAP Integration in DB2 UDB Using Microsoft Active Directory
    		Appendix I. Tuning DB2 UDB in the IBM LDAP Environment
    		Appendix J. DB2 Support Information
    		Appendix K. DB2 Connect Implementation
    		Appendix L. Sample Questions
    		Appendix M. Answers to Sample Questions
    		About the CD-ROM
    		Article