Creating user mappings for Db2 data sources

A user mapping defines an association between a user ID and password at the federated server and the corresponding user ID and password at the data source server.

About this task

Whether or not user mappings are required for Db2 data sources depends on the configuration of the federated environment. If the environment uses federated trusted contexts and proxy authentication, none or only a few user mappings may be required. For best results, plan and set up federated trusted contexts before you create user mappings.

Procedure

Use one of the following methods to create the user mappings for an Oracle data source:
Method Description
Use Administer/Remote Tables in DSM.

In the Nickname Explorer tab, click Manage Servers. In the Manage Servers tab, click Manage User Mappings > Create.
Issue the CREATE USER MAPPING statement to map the local user ID to the Db2 server user ID and password.
For example: 
CREATE USER MAPPING 
  FOR local_userID 
  SERVER server_definition_name
  OPTIONS (REMOTE_AUTHID 'remote_userID', 
  REMOTE_PASSWORD 'remote_password')
The REMOTE_AUTHID is the connect authorization ID, not the bind authorization ID.