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 multivendor.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.