Previous Page TOC Index Next Page

APPENDIX B CONFIGURATION PARAMETERS


By managing the parameters of your SOLID Server, you can modify the environment, performance, and operation of the server.

When SOLID Server is started, it attempts to open the configuration file solid.ini in the current directory. The configuration values for the server parameters are included in this file. If the file does not exist, SOLID Server will use the default settings for the parameters. Also, if a value for a parameter is not set in the solid.ini file, SOLID Server will use a default value for the parameter. The default values depend on the operating system you are using.

Generally, the default settings offer the best performance and operability, but in some special cases modifying a parameter will improve performance. You can change the parameters either by using the SOLID Remote Control parameter page or by editing the configuration file solid.ini. The configuration file format is similar to the format found in MS Windows and OS/2.

General Section

[General]

Description

Default

MaxOpenFiles

the maximum number of files kept concurrently open during SOLID Server sessions

OS depend.

BackupDirectory

the directory for backup files

No default

BackupCopyLog

if set to yes, backup operation will copy log files to the backup directory

yes

BackupDeleteLog

if set to yes, old log files will be deleted after backup operation

yes

BackupCopyIniFile

if set to yes, solid.ini file will be copied to the backup directory

yes

Checkpoint
Interval

the number of inserts made in the database that causes automatic checkpoint creation

5000

MergeInterval

the number of index inserts made in the database that causes the merge process to start

Cache size depend.

Readonly

if set to yes, database is set to read-only mode

no

LongSequential
SearchLimit

the number of sequential fetches after which search is treated as long sequential search

500

SearchBuffer
Limit

the maximum percentage of search buffers from the total buffered memory reserved for open cursors

50

Transaction
HashSize

the hash table size for incomplete transactions

Cache size depend.

UseIOThreads

if set to yes, IO threads are used; if set to no, IO threads are not used

no

IndexFile Section

[IndexFile]

Description

Default

FileSpec_[1-N]

the file name followed with maximum size (in bytes) of that database file, for example:
c:\sol1.db 2000000

This file must be stored to a local drive using local disk names to avoid problems with network I/O and to achieve better performance.

solid.db 2147483647

BlockSize

the block size of the index file in bytes; use power of 2 kb: minimum 2048, maximum 16384

8192

CacheSize

the size of database cache memory for the server in bytes; the minimum 512 kb

OS depend.

ExtendIncrement

the number of blocks that is allocated at one time when SOLID Server needs to allocate more space for the database file

50

ReadAhead

sets the number of prefetched index leafs during long sequential searches

4

PreFlushPercent

Percentage of page buffer which is kept clean by preflush thread

5

Logging Section

[Logging]

Description

Default

LogEnabled

whether logging is enabled or not

yes

LogWriteMode

the supported log write methods are:

0: the ping-pong method

1: the group commit method

2: the overwriting method

see chapter Database Maintenance for more specific information

0

BlockSize

the block size of log files

2048

MinSplitSize

when this file size is reached, logging will be continued to the following log file after the next checkpoint

1 MB

FileNameTemplate

the path and naming convention used when creating log files; template characters are replaced with sequential numbering; for example:
c:\solid\log\sol#####.log

This file must be stored to a local drive using local disk names to avoid problems with network I/O and to achieve better performance.

sol#####.log

DigitTemplate
Char

the template character that will be replaced in the name template of the log file

#

Communication Section

[Com]

Description

Default

Listen

the network name for server; the protocol and name that SOLID Server uses when starting listening to the network

OS depend.

Connect

the network name for client; the protocol and name that a SOLID Server client uses for server connection; in a Windows environment ODBC Data Source Name overrides the value of this parameter

OS depend.

MaxPhysMsgLen

the maximum length of a single physical network message in bytes; longer network messages will be split into smaller messages of this size

OS depend.

ReadBufSize

the buffer size in bytes for the data read from the network

OS depend.

WriteBufSize

the buffer size in bytes for the data written into the network

OS depend.

AllowYield

Windows only; controls whether communication is allowed to yield control to other running tasks or not

no

SelectThread

if set to yes a separate selector thread is started for every listening session

OS depend.

Trace

if parameter set to yes, trace information on network messages is written to a file specified with the TraceFile parameter

no

TraceFile

if parameter Trace is set to yes, trace information on network messages is written to a file specified with this parameter

soltrace.out

Data Sources

[Data Sources]

Description

Default

<logical name> =
<network name>,
<Description>

These parameters can be used to give a logical name to a SOLID Server. These parameters are

NOTE! This parameter is new in SOLID Server 2.2.

10

Server Section

[Srv]

Description

Default

RowsPerMessage

the number of rows returned from the server in one network message

10

ConnectTimeOut

specifies the continuous idle time in minutes after that an connection is dropped; negative or zero value means infinite

480

AbortTimeOut

specifies the time in minutes after that an idle transaction is aborted; negative or zero value means infinite

120

Threads

the number of threads used for database access in SOLID Server; When SMP support is not enabled the maximum number of threads in the server is limited to 5.

OS depend.

Echo

if set to yes, contents of solmsg.out file are displayed also at the server’s command window

no

ReadThreadMode

possible values are 0, 1 and 2, the meanings are following
0: network reads are done in database tasks
1: network reads are done in the server thread
2: network reads are done in separate read threads

OS depend.

Name

the informal name of the server, equivalent to the -n command line option


AllowConnect

if set to no only connections from Remote Control are allowed

yes

MessageLogSize

defines the maximum size of the solmsg.out file in bytes

OS depend.

SQL Section

[SQL]

Description

Default

Info

set the level of informational messages [0-8] printed from the server; information is written into file defined by parameter InfoFileName, (0=no info, 8=all info)

0

SQLInfo

set the level of informational SQL level messages [0-8]
; information is written into file defined by parameter InfoFileName,
(0=no info, 8=all info)

No default

InfoFileName

default global info file name

SOLTRACE.OUT

InfoFileSize

maximum size of the info file

No default

InfoFileFlush

if set to yes, flushes info file after every write operation

Yes

SortArraySize

the size of the array that SQL uses when ordering result set; for optimal performance this should be as big as the biggest retrieved result set that cannot be ordered by key values; for large sorts use external sorter

OS depend.

JoinPathSpan

the depth of the SQL parse tree that SQL optimizer will span through when selecting the correct joining strategy

3

ProcedureCache

the size of cache memory for parsed procedures in number of procedures

5

UseRangeEstimates

SQL estimator is capable of estimating ranges (e.g. A>1 AND A<5). Feature can be turned of by using this parameter.

NOTE! This parameter is new in SOLID Server 2.2.

Yes

Sorter Section

[Sorter]

Description

Default

MaxCacheUse
Percent

maximum percentage of cache pages used for sorting; range from 10% to 50%


MaxMemPerSort

maximum memory available in bytes for one sort


MaxFilesTotal

maximum number of files used for sorting


TmpDir_[1-N]

name of the directory that contains temporary files created during sorting

No default

Previous Page TOC Index Next Page

Copyright © 1992-1997 Solid Information Technology Ltd All rights reserved.