Configuring the c-tree Server

c-tree looks for a file called ctsrvr.cfg located in the same directory or the server executable. If this file is missing, the default settings are used.

It’s possible to use an alternate configuration file through the command line option CTSRVR_CFG.

Example for Windows:

ctreesql.exe CTSRVR_CFG C:\etc\customer1.cfg

Example for Unix/Linux:

./ctreesql CTSRVR_CFG /etc/customer1.cfg

Keywords in the configuration file must be followed by a value and are not case-sensitive.

Commented lines have a semicolon as first digit.

The table below lists the most commonly used configuration keywords. Refer to the c-tree Server Administrator's Guide for a complete list of keywords.

CONNECTIONS <number_of_connnections>	The maximum number of connections to the c-tree Server. Typically, servers are activated to support up to one of the following values for concurrent user connections: 8, 16, 32, 64, 128, 256, 512, or 1024. However your particular c-tree Server may be customized with a different value for connections.
COMM_PROTOCOL <protocol>	Specifies a communications module loaded by the Server. Possible values:   F_TCPIP FSHAREMM DISABLE   If no protocol is specified, then the default system communication protocol is used.
COMPATIBILITY TCPIP_CHECK_DEAD_CLIENTS	When this flag is present, the c-tree server recognizes when a connection between the client and the server, for some reason is lost. The c-tree server can automatically remove the connection and release the files and records related with the lost connection. See also DEAD_CLIENT_INTERVAL <seconds>.
DAT_MEMORY <byltes>	The memory allocated to the data cache, in bytes.   The default value is 225000.
DEAD_CLIENT_INTERVAL <seconds>	The number of seconds of client idle time after which the server checks the connection for that client. The default nsec value is 1800 (30 minutes), with a minimum of 120 (2 minutes).   COMPATIBILITY TCPIP_CHECK_DEAD_CLIENTS is required to enable the checking. Otherwise, no check is made.
FILES <number_of_files>	The maximum number of data files and indices where each index counts toward this total. For example, an index file which supports (i.e., contains as separate index members) three different keys counts as three files towards the FILES total.   The default value is 1000.
IDX_MEMORY <bytes>	The memory allocated to the index cache, bytes.   The default value is 225000.
MAX_DAT_KEY <number_of_indices>	Maximum number of indices per data file.   The default value is 64.
MAX_KEY_SEG <number_of_segnments>	Maximum number of key segments allowed per index.   The default value is 16.
MAX_FILES_PER_USER <number_of_files>	The maximum number of data files and indices (where each index counts toward this total) per client connection.   The default value is 2048.
SERVER_NAME <name>	A name assigned to c-tree Server, instead of the default name.   The default value is FAIRCOMS.
SERVER_PORT <port>	A port assigned to c-tree Server, instead of the default port.   The default value is 5597.
SERVER_DIRECTORY <directory>	Working directory of the c-tree Server. This directory is used to resolve all relative paths of c-tree files. By default the working directory is the directory in which the c-tree Server has been started.
LOCAL_DIRECTORY <directory>	Base directory for c-tree files. This directory is used to resolve all relative paths of c-tree files. If LOCAL_DIRECTORY is a relative path, then it‘s appended to SERVER_DIRECTORY. If omitted, only SERVER_DIRECTORY is used to resolve relative paths of c-tree files.
CONSOLE NO_SHUTDOWN_PROMPT	If present, ctsrvr will not prompt for administrator password when closed (Windows only).
CONSOLE TOOL_TRAY	If present, ctsrvr will start minimized in the system tray (Windows only).
SQL_DATABASE <db_name>	Name of the database. By default this entry is set to "ctreeSQL". Database files are automatically created during the first startup. This name must be used by ctutil -sql* op-codes and external SQL tools to connect and operate with isCOBOL ISAM Server.