Feedback
To configure how the federated server and its users interact with a data source, set and modify wrapper, server, user mapping, nickname, and column options.
The following tables list the options that apply to this data source and identify the required options that you must specify in the CREATE WRAPPER and CREATE SERVER statements.
| Name | Description |
|---|---|
| DB2_FENCED | Required. Specifies whether the wrapper runs in fenced mode or in trusted mode. Valid values are Y and N. The default is N; the wrapper runs in trusted mode. |
| DB2_UM_PLUGIN | Specifies the implementation of the user mapping plug-in. For a plug-in written in Java, specifies a case-sensitive string for the class name that corresponds to the user mapping repository class. For example, "UserMappingRepositoryLDAP". For a plug-in written in C, specifies any valid C library name. |
| DB2_UM_PLUGIN_LANG | Specifies the language of the user mapping plug-in. Valid values are Java and C. The default is Java. |
| PROXY_SERVER_NAME | Specifies the name or IP address of the proxy server. This option is required if the value of PROXY_TYPE is HTTP or SOCKS. Valid IP addresses are in IPv4 (dot-separated) format or in IPv6 (colon-separated) format. Use IPv6 format only if IPv6 is configured. |
| PROXY_SERVER_PORT | Specifies the port or service name for the proxy service on the proxy server. This option is required if the value of PROXY_TYPE is HTTP or SOCKS. Valid values are a decimal port number from 1 to 32760 or a service name. |
| PROXY_TYPE | Specifies the proxy type to use to access the Internet when the federated server is behind a firewall. Valid values are NONE, HTTP, and SOCKS. The default value is NONE. If you set this option to HTTP or SOCKS, you must also specify the PROXY_SERVER_NAME and PROXY_SERVER_PORT. |
| Name | Description |
|---|---|
| CASE_SENSITIVE | Specifies whether the BioRS server treats names in a case-sensitive manner. Valid values are Y and N. The default is Y; names are treated in a case-sensitive manner. In the BioRS product, a configuration parameter controls the case sensitivity of the data that is stored on the BioRS server. The CASE_SENSITIVE option and the configuration parameter must specify the same case sensitivity. If you need to change the value of the CASE_SENSITIVE option after you create the server definition, you must drop the server definition and create the definition and all nicknames again. |
| DB2_MAX_ASYNC_REQUESTS_ PER_QUERY | Specifies the maximum number of concurrent asynchronous requests from a query. Valid values are from -1 to 64000. The default is 1. -1 specifies that the federated query optimizer determines the number of requests. 0 specifies that the data source cannot accommodate additional asynchronous requests. |
| DB2_UM_PLUGIN | Specifies the implementation of the user mapping plug-in. For a plug-in written in Java, specifies a case-sensitive string for the class name that corresponds to the user mapping repository class. For example, "UserMappingRepositoryLDAP". For a plug-in written in C, specifies any valid C library name. |
| DB2_UM_PLUGIN_LANG | Specifies the language for the user mapping plug-in. Valid values are Java and C. The default is Java. |
| NODE | Required. Specifies the DNS host name or IP address of the system on which the BioRS query tool is available. Valid IP addresses are in IPv4 (dot-separated) format or IPv6 (colon-separated) format. Use IPv6 format only if IPv6 is configured. The default value is localhost. |
| PORT | Specifies the port for connections to the BioRS server. Valid values are a numeric port or a TCP/IP service name. The default is 5014. |
| PROXY_AUTHID | Specifies the user name for proxy server authentication. |
| PROXY_PASSWORD | Specifies the password for proxy server authentication. |
| PROXY_SERVER_NAME | Specifies the name or IP address of the proxy server. Valid IP addresses are in IPv4 (dot-separated) format or in IPv6 (colon-separated) format. Use IPv6 format only if IPv6 is configured. |
| PROXY_SERVER_PORT | Specifies the port or service name for the proxy service on the proxy server. Valid values are a decimal port number from 1 to 32760 or a service name. |
| PROXY_TYPE | Specifies the proxy type to use to access the Internet when the federated server is behind a firewall. Valid values are NONE, HTTP, and SOCKS. The default value is NONE. |
| TIMEOUT | Specifies the maximum time, in minutes, that the federated server waits for a response from the remote server. The default is 10. |
| Option | Description |
|---|---|
| GUEST | Specifies that the GUEST BioRS authentication ID is used to perform operations. Valid values are Y and N. The default is N; the GUEST BioRS ID is not used. This option is not valid if you specify the REMOTE_AUTHID and REMOTE_PASSWORD options. |
| PROXY_AUTHID | Specifies the user name for proxy server authentication. |
| PROXY_PASSWORD | Specifies the password for proxy server authentication. The password is encrypted when it is stored in the federated database catalog. |
| REMOTE_AUTHID | Specifies the remote user ID to which the local user ID is mapped. If you do not specify this option, the ID that is used to connect to the federated database is used. |
| REMOTE_PASSWORD | Specifies the remote password for the remote user ID. If you do not specify this option, the password that is used to connect to the federated database is used. |
| Option | Description |
|---|---|
| REMOTE_OBJECT | Specifies the name of the BioRS databank that is associated with the nickname. This name determines the schema and the BioRS databank for the nickname. The name also specifies the relationship of the nickname to other nicknames. The case sensitivity of this option depends on the case sensitivity of the BioRS server and on the value of the CASE_SENSITIVE server option. You cannot use the ALTER NICKNAME statement to change or delete this name. If the name of the BioRS databank changes, you must delete the nickname and then create it again. |
| TIMEOUT | Specifies the maximum time, in minutes, to wait for a response from the data source server. The default is 10. |
| Option | Description |
|---|---|
| ELEMENT_NAME | Specifies the BioRS element name. The case sensitivity of this name depends on the case sensitivity of the BioRS server and on the value of the CASE_SENSITIVE server option. You must specify the BioRS element name only if it is different from the column name. |
| IS_INDEXED | Specifies whether the corresponding column is indexed and, therefore, can be referenced in a predicate. Valid values are Y and N. The default is N; the column is not indexed. |
| REFERENCED_OBJECT | Specifies the name of the BioRS databank that is referenced by the current column. The case sensitivity of this name depends on the case sensitivity of the BioRS server and on the value of the CASE_SENSITIVE server option. This option is valid only for columns that have the BioRS data type of Reference. |