1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
|
;/*****************************************************************\
;** filename * solidsrv.ini
;** *
;** description * Lists configuration parameters of SOLID Server.
;** *
;** * For a more complete description of the
;** * parameters please refer to SOLID Server
;** * Administrator's Guide Appendix B.
;** *
;** Copyright (C) Solid Information Technology Ltd 1997
;\*****************************************************************/
;*******************************************************************
; The following are the default values for parameters for
; SOLID Server 2.2. Values which have no values or values
; that depend on other parameters are marked as <no default>.
;
; These default values are set by the server automatically. For
; keeping your solid.ini file readable, it is recommended that you
; do not use this file as your initialisation file. Use this file
; as a reference to the parameters only.
;*******************************************************************
[Srv]
ConnectTimeOut = 480
; Idle time in minutes allowed for connections before they
; are dropped. If set to zero, timeout is inactive.
AbortTimeOut = 120
; Idle time in minutes allowed for transactions before they
; are aborted. If set to zero, timeout is inactive.
RowsPerMessage = 10
; Number of rows returned from server in one network message.
Threads = 2
; Number of threads used for database access.
Echo = no
; I set to 'no', server messages are not displayed in the
; command shell window where the server was started from.
ReadThreadMode = 0 ; network reads are done in database tasks
; ReadThreadMode=1 ; network reads are done in the server thread
; ReadThreadMode=2 ; network reads are done in separate read threads
Name = <no default>
; Gives a specific name to a database. This name is displayed in
; server startup messages and with an icon in Windows operating
; systems.
AllowConnect = yes
; If set to 'yes', the database is open, new connects are accepted.
MessageLogSize = 60000
; Defines the maximum size of the solmsg.out file in bytes.
; When this maximum size is reached file is renamed to solmsg.bak
; and a new solmsg.out file is created.
;*******************************************************************
[General]
MaxOpenFiles = 30
; Maximum number of open files during SOLID Server session.
; Default for NLM version is 15.
BackupDirectory = backup
; Default directory for backups.
BackupCopyLog = yes
; When set to 'yes' log files are copied into backup directory
; in backup operation.
BackupDeleteLog = yes
; If set to 'yes', unnecessary log files are deleted after a
; backup operation has been completed successfully.
BackupCopyIniFile = yes
; SOLID.INI file is copied into backup directory with the
; backup operation.
CheckpointInterval = 5000
; Number of index inserts before a checkpoint is automatically
; generated.
MergeInterval=10000
; Number of index inserts before a merge process is
; automatically activated.
ReadOnly = no
; Sets the database to read only mode. In this mode no data can
; be written to the database.
LongSequentialSearchLimit = 500
; If a query returns more rows than this limit, the I/O manager
; switches to long sequential search mode.
SearchBufferLimit = 50
; Maximum percentage of cache allocated for search buffers.
TransactionHashSize = <no default>
; Hash table size for incomplete transactions.
TransactionEarlyValidate = yes
; Transaction early validating is used when this parameter
; is set to yes.
UseIOThreads = No
; All database file operations (excluding logging) will use
; multiple threads. Parameter is ignored in single thread
; environments.
;*******************************************************************
[IndexFile]
BlockSize = 8192 ; bytes
; Blocksize of the database file. This parameter can not be
; changed after the database file has been created.
;
; It is suggested that the blocksize of a database file when used
; in Windows 3.X systems is set to the same or larger values as
; the blocksize of the harddisk. See Readme.Txt of SOLID Server
; for Windows 3.X for more detailed information.
ExtendIncrement = 50
; Number of blocks allocated for database file when new space is
; needed.
CacheSize = 2097152
; the default value of CacheSize parameter depends on the server
; platform
; OpenVMS: 4194304
; UNIXes: 4194304
; OS/2: 2097152
; WinNT: 2097152
; NLM: 1048576
; Win16: 524288
FileSpec_1 = solid.db 2147483647
; Defines the name, location and maximum size of the database file.
; FileSpec_2=solid2.db 2147483647 ; specifies second database file.
ReadAhead = 4
; Sets the number of index leaves that are prefetched in long
; sequential searches.
PreFlushPercent = 5
; Percentage of cache that is kept empty. When new cache blocks are
; needed, they can be taken immediately without writing the old
; contents onto the disk.
;*******************************************************************
[Logging]
LogEnabled = yes
; Transaction logging is enabled.
BlockSize = 2048 ; bytes
; Block size of log files is 2048 bytes.
FileNameTemplate = sol#####.log
; Name of log files is sol#####.log where # is a template character.
DigitTemplateChar = #
; Character that is used in the filenametemplate. These template
; characters are replaced by a incrementing number in the actual
; filenames.
MinSplitSize = 1048576
; This parameter describes a limit of logfile size. When this size
; is reached, logging will be continued to next log file after next
; checkpoint creation.
LogWriteMode = 0 ; the ping-pong method
;LogWriteMode=1 ; the group commit method
;LogWriteMode=2 ; the overwriting method
;*****************************************************************
[SQL]
Info=0 ; no output
;Info=1 ; table, index and view info in SQL format
;Info=2 ; level 1 + SQL execution graphs
;Info=3 ; level 2 + some SQL estimate info, Solid selected key name
;Info=4 ; level 3 + all SQL estimate info, Solid selected key info
;Info=5 ; level 4 + Solid info also from discarded keys
;Info=6 ; level 5 + Solid table level info
;Info=7 ; level 6 + SQL info from every fetched row
;Info=8 ; level 7 + Solid info from every fetched row
SortArraySize = 1000
; Size of the internal sorting buffer. If external sorting is used,
; external sorting is used for result sets bigger than this limit.
JoinPathSpan = 4
; Defines the depth the SQL optimizer goes to find the shortest
; join path in table joins.
ProcedureCache = 5
; Amount of procedures cached in memory per connection.
;*****************************************************************
[Com]
Listen = <no default>
; The network name for server; the protocol and name that SOLID
; Server uses when starting listening to the network.
Client = <no default>
; 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 value
; of this parameter.
MaxPhysMsgLen = 8192 ; bytes
; Sets the maximum communication message length.
ReadBufSize = <no default>
; Size of the communication read buffer.
WriteBufSize = <no default>
; Size of the communication write buffer.
AllowYield = no
; Controls the yielding in Windows. Default No disallows the
; yielding during communication operations.
Trace = no
; If 'yes', network trace is written to TraceFile.
; Used for debugging connection problems.
TraceFile = solmsg.out
; Name of a file where communication trace is written.
;*****************************************************************
[Sorting]
MaxCacheUsePercent = 25
; Maximum percentage of cache pages used for sorting.
; Values may range from 10% to 50%.
MaxMemPerSort = <no default>
; Maximum memory available in bytes for one sorting.
MaxFilesTotal = 100
; Maximum number of files used for sorting.
TmdDir_1 = <no default>
; Name of the directory that may contain temporary files
; that are created during sorting. This directory has to have
; write access for solid processes.
; TmpDir_2 = ; Defines second sort directory.
|
