Administration Guide

Enabling a Federated System

DB2 Enterprise Edition (EE) and DB2 Enterprise - Extended Edition (EEE) can support federated databases. To enable a federated system:

1. Select the Distributed Join for DB2 Databases installation option of DB2 EE or EEE during installation.
2. If including Oracle databases in your federated system, install DB2 Relational Connect. For more information, refer to the Installation and Configuration Supplement.
3. Set the database manager configuration parameter federated to "YES".
4. Create wrappers, servers, and nicknames (see Chapter 14, Creating a Database for more information).
5. Create additional objects, or set options as required (see Chapter 13, Before Creating a Database for more information).