Configuring access to Db2 data sources

To configure a federated server to access Db2 family data sources, you must provide the federated server with information about the data sources and objects that you want to access.

Before you begin

  • Verify the set up of the federated server.

Procedure

  1. Register the Db2 wrapper.
  2. Register the server definitions for a Db2 data source.
  3. Create the user mappings for a Db2 data source.
  4. Test the connection to the Db2 data source server.
  5. Register the nicknames for the Db2 tables and views.