Global parameters for the configuration file

Define all global configuration properties 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 properties apply to all services. These parameters are used with sp_configure.

**Table 2-1: Global parameters for the configuration file**
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(NT)
errorlog	Full path name to the error log file	$SYBASE/$SYBASE_DCO/servername.log
interfaces	Full path to the directory of the interfaces file
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 DirectConnect for Oracle	25
network_tracing	Enables packet tracing between the client and DirectConnect 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

administrator

This configuration parameter defines who can execute the sp_shutdown, sp_configure, sp_addservice, and sp_dropservice commands. If you want the user “ozzie” to be the authority to shut down DirectConnect, the value of the administrator configuration parameter must be “ozzie”. This user must also be a valid Oracle user. If this parameter is not defined, no one will be able to shut down DirectConnect for Oracle. Only one user can have administrator privileges. This parameter is case sensitive.

Example 1

administrator = ozzie

This parameter is dynamic.

charset

This is the default character set for DirectConnect for Oracle is iso_1. On HP, the default is Roman8, and on Windows the default is cp850.

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. The default character set for DirectConnect is:

Example 2

charset = cp850

This parameter is static.

certificate_file

This is the name of the certificate file used for SSL.

certificate_password

This is the password associated with the certificate file.

errorlog

This parameter sets the full path name to the error log file. It defaults to: $SYBASE/$SYBASE_DCO/DCO-12_5/install/servername.log.

This parameter is static.

interfaces

This sets the full path to the directory of the interfaces file.

This parameter is static.

language

This sets the default language used by DirectConnect 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 the DirectConnect’s client. The syntax is:

Example 3

language = us_english

This parameter is static.

max_packetsize

This sets the maximum packet size that can be negotiated for a client connection. Without this parameter, the maximum packet size defaults to 2048. If you increase the packet size used in Adaptive Server Enterprise through sp_configure (using “ctlib packet size”) to a value greater than 2048, you need to set this value to match.

Do not set this parameter larger than necessary, because this amount of memory is allocated whether used or not. The maximum packet size supported is 32,256 bytes. The syntax is:

Example 4

max_packetsize = 4096

This parameter is static.

maxpagesize

This sets the maximum page size for transfers using the bulk copy interface. The defaults is 4096 bytes.

This parameter is static.

max_stacksize

This sets the maximum stack size that is allocated for each user.

This parameter is dynamic.

max_textsize

This sets the maximum size transferred when a text or image column is queried. The default is 32,768 bytes.

This parameter is dynamic.

max_threads

This sets the maximum number of Open Server threads. The default is max_users * 4.

This parameter is static.

max_users

This defines the total number of users that can be connected to a DirectConnect concurrently. As the number of users increase, additional resources are required. max_users cannot be set to a value less than 5.

Example 5

To support 50 concurrent connections, set max_users as shown below:

max_users = 50

This parameter is static.

network_tracing

This enables packet tracing between the client and DirectConnect for Oracle. It also enables tracing for internal communications between threads.

Trace entries between the client and DirectConnect for Oracle are recorded in $SYBASE/$SYBASE_DCO/SERVERNAME.log.

Internal trace entries are recorded in $SYBASE/$SYBASE_DCO$/SERVERNAME.tds.

Example 6

network_tracing = 1

This feature should not be used unless required, because it will cause log files to fill up quickly.

srv_traceflags

This enables tracing of Open Server events. A string containing numeric flag identifiers is used to generate Open Server diagnostic information.

This parameter is static.

Open Server trace flags

Use the srv_traceflags parameter to turn on trace flags to log Open Server diagnostic information.

**Table 2-2: Open Server trace flags**
Trace flag	Description
1	Traces TDS headers
2	Traces TDS data
3	Traces attention events
4	Traces message queues
5	Traces TDS tokens
6	Traces Open Server events
7	Traces deferred event queues
8	Traces network requests

For example:

sp_configure DCSERVER, ’srv_traceflags’, ’3’

This parameter is dynamic.

text_chunksize

This sets the size of each text or image chunk when retrieving text and image data.

This parameter is dynamic.

trusted_roots_file

This is the name of the trusted roots file.