Define all global configuration parameters as shown in the service entry that has the same name as the configuration file itself.
The 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, and sp_dropservice commands. For example, for “ozzie” to be the authority to shut down DirectConnect, set the value of the administrator configuration parameter to “ozzie”. This user must also be a valid Oracle user. If you do not define this parameter, no one can shut down ECDA Option for Oracle. Only one user can have administrator privileges. This parameter is case-sensitive and dynamic. |
None |
certificate_file |
The name of the certificate file used for SSL. |
None |
certificate_password |
The password associated with the certificate file. |
|
charset |
The default charset used by Open Server. The character set is requested when a connection is made to Oracle. Results are converted into the client's character set when they are sent to the client. This parameter is static. The syntax is:
charset = cp850 |
iso_1, Roman8 (HP), cp850 (Windows) |
errorlog |
Sets the full path name to the error log file. This parameter is static. |
<install_dir> /DCO-15_0/servername.log |
interfaces |
Sets the full path to the directory of the interfaces file. This parameter is static. |
<install_dir>/interfaces |
language |
Sets the default language used by ECDA Option for Oracle. However, when a connection is made to Oracle, the language requested is the client language, which changes the language of messages in the log file. The language used to connect to Oracle is passed on from DirectConnect client. This parameter is static. The syntax is:
language = us_english |
us_english |
max_packetsize |
Sets the maximum packet size that can be negotiated for a client connection. If you increase the packet size used in Adaptive Server through sp_configure (using “ctlib packet size”) to a value greater than 2048, you must also set this value to match. Do not set this parameter larger than necessary, because the amount of memory you specify here is
allocated whether used or not. The maximum packet
size supported is 32,256 bytes. The syntax
is:
max_packetsize = 4096 This parameter is static. |
2048 |
max_pagesize |
Sets the maximum page size for transfers using the bulk-copy interface. This parameter is static. |
4096 bytes |
max_stacksize |
Sets the maximum stack size that is allocated for each user. This parameter is dynamic. |
100352 |
max_textsize |
Sets the maximum size transferred when a text or image column is queried. This parameter is dynamic. |
32,768 bytes |
max_threads |
Sets the maximum number of Open Server threads. This parameter is static. |
max_users * 4 |
max_users |
Defines the total number of concurrent users that can be connected to ECDA Option for Oracle / DirectConnect concurrently. As the number of users increase, additional resources are required. You cannot set max_users to a value less than 5. This parameter is static. |
25 |
network_tracing |
Enables packet tracing between the client and ECDA Option for Oracle. It enables tracing for internal communications between threads. Trace entries between the client and ECDA for Oracle are recorded in <install_dir>/DCO-15_0/SERVERNAME.log. network_tracing = 1 Use this feature only when required; using it quickly fills log files. |
0 |
srv_traceflags |
String containing numeric flag identifiers used to generate Open Server diagnostic information. Internal trace entries are recorded in <install_dir>/DCO-15_0/SERVERNAME.tds. This parameter is static. |
0 |
text_chunksize |
Sets the size of each text or image chunk when retrieving text and image data. This parameter is dynamic. |
32768 |
trusted_roots_file |
The name of the trusted roots file. |