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.

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.

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.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF