1.7. Federated Support

Federation allows you to query and manipulate data stored on other servers and in other RDBMSs. When you issue an SQL statement in a federated environment, you may actually be accessing information from multiple databases and potentially multiple RDBMSs (see Figure 1.10).

Figure 1.10. DB2 federation

[View full size image]

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 DB2 Information Integrator product described in section 1.9.