Creating a nickname for a nickname

Create a nickname for a nickname to allow one data source to access a nickname on another data source.

About this task

For example, imagine that you have a federated server on AIX® and a federated server on Windows. You want to access a Microsoft Excel spreadsheet from both federated servers; however, the Excel wrapper is available only for federated servers on Windows.

Procedure

  1. On the Windows federated server, install Federation component.
  2. Configure the Windows federated server to access Excel data sources.
  3. On the Windows federated server, create a nickname for the Excel spreadsheet.
  4. On the AIX federated server, install Federation component.
  5. Configure the AIX federated server to access Db2® family data sources.
  6. On the AIX federated server, create a nickname for the nickname of the Excel spreadsheet on the Windows federated server.