Create Server wizard

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.


Feedback