|
|
|
The FairCom DB Server Configuration File gives the Administrator much more control over the operation of the FairCom DB Server than covered so far. The following detailed list of additional keywords is provided with explanations and default values for each. For completeness, all configuration options supported by the FairCom DB Server are included in this manual. The keywords in this section are listed in alphabetical order.
Note: The options listed in this section require in-depth knowledge of the operating system and hardware configurations of the specific computing environment the FairCom DB process is operating in and, as such, are intended for the appropriate personnel as required. We assume the FairCom DB Administrator will coordinate with the application developer and other members of their operations team as needed.
Overrides the default number of hash bins for each user.
Specifies the spin count for FairCom DB critical sections on Windows.
Sets the thread stack size in kilobytes on Unix/Linux (non-Windows) systems.
Sets the time interval between calls to the aggregating functions.
Controls performance optimizations for tables supporting HOT ALTER TABLE.
Specifies the sleep time for a thread synchronization object on Solaris systems (latch). Requires a custom build.
Specifies the spin count for a thread synchronization object on Solaris systems (latch). Requires a custom build.
Specifies the number of hash bins available to the lock hash algorithm.
Sets the maximum number of lock hash bins.
Sets the average number of locks in each hash bin.
Sets the fraction of the hash bins to be reorganized.
Sets the number of seconds a user thread waits for the internal threads to close the file before retrying.
Specifies the maximum number of file handles to store keys that do not fit in memory.
Specifies the value in kilobytes that can be used for storing key values in memory.
Sets the maximum transaction isolation level at which SQL clients can operate.
The MAX_STORE keyword limits the per-connection amount of temporary disk space available for SQL query execution.
Reuses empty index nodes after the specified number of seconds.
Specifies how deep (the number of nodes) to inspect the delete node queue for previously deleted index nodes before adding already existing deleted nodes to the queue.
Sets the time limit in seconds that a data cache page can remain dirty before it is written to the file system cache.
Sets the time limit in seconds that an index buffer can remain dirty before it is written to the file system cache.
Estimates the distinct key count for a partitioned index file instead of calculating the exact distinct key count by summing the distinct key counts for each partition of that index.
Specifies the number of hash bins available to the preimage hash algorithm.
Sets the fraction of hash bins to be reorganized.
Enables a feature to perform a checkpoint file system flush without blocking all of the mutexes.
Limit the time the server will wait before failing a ctQUIET() call.
Deprecated as of FairCom DB V9.3. See LOCAL_DIRECTORY (LOCAL_DIRECTORY, LOCAL_DIRECTORY).
OEM-specific abilities to change the number of sessions under program control. Not for general use.
Can be used to limit JVM memory.
Enables logic to prepare more resultset rows than requested by the client.
Disables internal thread synchronization (add work/remove work) logic in early V9 server lines. Consult with the FairCom engineering team.
Enable or disable SQL to add the changeid field to new tables.
Deletes the MRT host (physical file) when performing drop table from SQL of the last MRT defined on the table.
Marks a section in the server configuration file ctsrvr.cfg to configure the LATTE sorting subsystem for FairCom DB SQL.
Specifies the number of seconds between log flushes. FairCom does NOT recommend the use of this option.
Reduces FairCom DB Server CPU activity level in non-preemptive environments, thus controlling when to put itself to sleep and when to wake up.
Sets the time limit in seconds that a data cache page can remain dirty before it is written to the file system cache.
Sets the time limit in seconds that an index buffer can remain dirty before it is written to the file system cache.
Specifies the microsecond duration of 64 consecutive yield calls. See the full explanation under UDEFER_THRESHOLD_USEC.
Specifies in microseconds the value below which yield calls are used.
Specifies the number of times to retry an ISAM add or update operation that fails with error VLEN_ERR. This option is disabled at compile-time by default.
