Installation and Configuration Supplement

Enabling Federated Database Functionality

To take advantage of federated database functionality:

On UNIX systems

During the installation of DB2 Universal Database you must select the Distributed Join for DB2 Data Sources option and optionally create an instance to use with this option. If you choose to create an instance, the FEDERATED parameter will be set to YES by default. If you choose to create an instance at a later date, you must manually set the FEDERATED parameter to YES for that instance.

This is only necessary if you are creating an instance using db2icrt. If you go back to using db2setup to either create or set up on existing instance, then the FEDERATED parameter will be set to YES again.

On Windows systems

Federated database functionality is enabled by default as part of the DB2 installation.