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.