A DB2 federated database system enables users and applications to refer to multiple database management systems or databases within a single SQL statement. You can, for example, perform a UNION between a DB2 table and an Informix view. A DB2 federated system includes a DB2 instance and database, and one or more data sources. Each data source consists of a non-DB2 DBMS and data.
Before setting up distributed join, you must do two things:
To set up distributed join for Informix data sources, enter the Informix client installation directory and the name of the Informix server. The DB2 Setup wizard will install a wrapper for the data source and set up distributed join to access it.
You can set up distributed join for data sources later by using the DB2 Setup wizard or the Command Line Processor (CLP). For more information on using DB2 Relational Connect to access non-DB2 data sources see the Federated Systems Guide.