- 1.1 Brief History of DB2
- 1.2 The Role of DB2 in the Information On Demand World
- 1.3 DB2 EDITIONS
- 1.4 DB2 Clients
- 1.5 Try-and-Buy Versions
- 1.6 Host Connectivity
- 1.7 Federation Support
- 1.8 Replication Support
- 1.9 IBM WebSphere Federation Server and WebSphere Replication Server
- 1.10 Special Package Offerings for Developers
- 1.11 DB2 Syntax Diagram Conventions
- 1.12 Case Study
- 1.13 Summary
- 1.14 Review Questions
1.7 Federation Support
Federation allows you to query and manipulate data stored on other servers and in other data servers. When you issue an SQL statement in a federated environment, you may actually be accessing information from multiple databases and potentially multiple data servers (see Figure 1.13).
Figure 1.13 DB2 federation
Federated support is included in DB2 when the other databases being accessed are part of the IBM DB2 family, that is, another DB2 database or an Informix database. For accessing databases from other vendors, refer to the IBM WebSphere Federation Server product described in Section 1.9.