Define all global configuration parameters as shown in the service entry that has the same name as the configuration file itself. This primary service name is also the server name. Global parameters apply to all services. These parameters are used with “sp_configure”.
Keyword |
Description |
Default |
---|---|---|
administrator |
Defines who can execute sp_shutdown, sp_configure, sp_addservice, sp_dropservice |
|
certificate_file |
The name of the certificate file used for SSL |
|
certificate_password |
The password associated with the certificate file |
|
charset |
The default charset used by Open Server |
iso_1, Roman8 (HP), cp850 (Windows) |
errorlog |
Full path name to the error log file |
<install_dir> /DCO-15_0/servername.log |
interfaces |
Full path to the directory of the interfaces file |
<install_dir>/interfaces |
language |
Available languages |
us_english |
max_packetsize |
Sets the maximum packet size that can be negotiated for a client connection |
2048 |
max_pagesize |
Sets the maximum page size for transfers using the bulk copy interface |
4096 |
max_stacksize |
Sets stack size |
100352 |
max_textsize |
Sets the maximum size transferred when a text/image column is queried |
32768 |
max_threads |
Set the maximum number of Open Server threads |
max_users * 4 |
max_users |
Defines the total number of concurrent users that can be connected to ECDA Option for Oracle |
25 |
network_tracing |
Enables packet tracing between the client and ECDA Option for Oracle |
0 |
srv_traceflags |
String containing numeric flag identifiers used to generate Open Server diagnostic information |
0 |
text_chunksize |
Sets the size of each text/image chunk when retrieving text/image data |
32768 |
trusted_roots_file |
The name of the trusted roots file |