Federated Systems (DB2)

A federated system consists of a DB2 instance that operates as a federated server, a database that acts as the federated database, one or more data sources, and clients (users and applications) that access the database and data sources. PowerDesigner provides support for federated servers for DB2 for Common Server v9.0 and higher through nicknames, servers, wrappers, and user mappings.

• Nicknames (DB2)
  A nickname is an identifier that an application uses to reference a data source object, such as a table or view. In a federated system, you use can nicknames to access data source objects and improve the performance of queries on remote data sources. Nicknames are supported for DB2 for Common Server v9.7 and higher.
• Servers (DB2)
  The instance owner supplies a name to identify the data source, along with the type and version of the data source, the database name for the data source (RDBMS only), and metadata that is specific to the data source. This information is called a server definition. Data sources answer requests for data and are servers in their own right. Servers are supported for DB2 for Common Server v9.7 and higher.
• Wrappers (DB2)
  Wrappers are mechanisms by which the federated server interacts with data sources. The federated server uses routines stored in a library called a wrapper module to implement a wrapper. Wrappers are supported for DB2 for Common Server v9.7 and higher.
• User Mappings (DB2)
  A user mapping is an association between an authorization ID on the federated server and the information that is required to connect to the remote data source. User mappings are supported for DB2 for Common Server v9.7 and higher.