Registering server definitions for Db2 data sources
The federated server requires authorization and password information to connect to each Db2 server. Because this authorization and password information is not stored in the global catalog, you must include it in each server definition.
Procedure
To register a server definition, use one of these methods:
| Method | Description |
|---|---|
| Use Administer/Remote Tables in DSM. | In the Nickname Explorer tab, click . If no servers exist, you are taken to the Create Server tab. |
Note: For the VERSION, if you used Db2 for z/OS® Version
8 to create the database in compatibility mode, you must specify Version
7.
When you register the server, you can specify additional server options in the CREATE SERVER statement. These options include general server options and server options that are specific to the data source. After the server definition is registered, use the ALTER SERVER statement to add or drop server options.
In Federation component ,
when you run the CREATE SERVER statement, the following server options
are automatically configured based on the configuration of your data
source:
- DATE_COMPAT
- NUMBER_COMPAT
- SAME_DECFLT_ROUNDING
- VARCHAR2_COMPAT