Federated Database System -- Working with

A federated database system is a multidatabase server that provides access to data sources that reside on different platforms, both IBM and multvendor.In a federated system, you can access all data, remote and diverse, and view the results of your queries from a single image as though the data were local.

To add a new data source to your federated system:

1. Connect to a DB2 database.

2. Create a wrapper for each database type that you want to include in your federated system.

3. Create a server to define a data source to the federated system.

4. Optional: If the user ID and password in DB2 is different from the user ID at the data source, create a user mapping.

5. Create a nickname for each table or view at the data source.

6. Query the table or view using DB2 database SQL.