Use the Create Server wizard to create the server definition for
a remote server so that you can connect to and access the data source.
The Create Server wizard guides you through the steps to define
a remote data source to a federated database. After you create the remote
server definition, the data source is added to the Defined Remote
Servers folder.
Create Server Definition page
Use this page to specify
the definition for the remote server.
- Server name
- Type a name for the remote server that you want to create.
- Server type
- Select the type of server that you want to define. The list is populated
with possible values for this data source.
- Server version
- Select the version of the server that you want to define. The list is
populated with possible values for this data source.
- Server options
- Check the server options that you want to define. The list is populated
with the possible options for this data source and the default values for
these options. The mandatory options are preselected.
- User information
- Type the user ID and password for the remote user of this data source.
This user information is required for only DB2® family data sources. The user ID specifies
the authorization ID under which any necessary actions are performed at the
data source when the CREATE SERVER statement is processed. This ID must hold
the authority (BINDADD or its equivalent) that the necessary actions require.
Create User Mapping Definition page
Use this wizard
page to create a user mapping definition for the server.
- Local user ID
- Type the user ID for the local user of this data source. This user ID
specifies the authorization name under which a user or application connects
to a federated database.
- Remote user information
- Type the user ID and password for the remote user of this data source.
Specify this information to register a user mapping to the server object of
the remote data source. Map the authorization name for the local federated
database to the user ID and password for the server object of the remote data
source.
Summary page
Verify the information that you specified
for creating the server definition for the remote data source. To change values,
click Back, and modify the settings. When you are ready to create the
remote server, click Finish.