sp_configure

Description

Displays or changes ECDA Option for Oracle configuration properties.

Syntax

server_name... sp_configure [service_name] [, config_name [, config_value]]

Parameters

service_name: is the name of the ECDA Option for Oracle service.

config_name: is the name of the configuration parameter to be displayed or modified.

config_value: is the value you assign to the configuration parameter.

Examples

Example 1

DCSERVER...sp_configure DCO_S1, connect_string, "ORA817.world"

Modifies the connect_string for service DCO_S1.

Usage

If no parameters are supplied, sp_configure will list all the services defined:
```
exec DCSERVER...sp_configure
```
sp_configure, with the service_name without a value, will list all of the configuration options for that service.
```
exec DCSERVER...sp_configure, DCSERVER0
```
sp_configure with the service_name (DCSRERVER0), and the option will display the current value of the option:
```
exec DCSERVER...sp_configure, DCSERVER0, max_users
```
If a value is supplied, such as “100” in the following example, sp_configure changes the option:
```
exec DCSERVER...sp_configure, DCSERVER0, max_users, 100
```
Languages and charsets cannot be displayed or edited with sp_configure. To change these properties, the configuration file must be edited manually.
When you execute sp_configure to modify a dynamic parameter:
- The configuration and run values are updated.
- The configuration file is updated.
- The change takes effect immediately for all new connections. Current connections are unchanged.
When you execute sp_configure to modify a static parameter:
- The configuration value is updated.
- The configuration file is updated.
- The change takes effect only when you restart ECDA Option for Oracle.
When issued with no parameters, sp_configure displays all the service names.
When issued with only the service_name parameter, sp_configure displays all the configuration information for the service.
If the config_name parameter is specified, but the config_value parameter is omitted, sp_configure displays the report for the configuration parameter specified.
For information on the individual configuration properties, see “Using the command line”.

Permissions

Only the ECDA Option for Oracle administrator can execute sp_configure.