See Also
Administration Guide
You are here: Administration Guide > Database Settings
ContentsIndexHome
PreviousUpNext
Database Settings
Database Settings

 

Database server settings can be specified as command line options and using the Windows registry. The sysconfig system table can be used to retrieve all settings and also be UPDATEd to set some of them. 

 

Command Line Options 

Command line options can be specified to the database executable in the form -<category>/<key>=<value>. Eg: 

    scimoredb.exe -startup/mode=1 -tran/maxlock=100

Any settings specified on the command line take precedence over registry values. 

 

Registry Values 

Registry values for instances are found in the HKEY_LOCAL_MACHINE\SOFTWARE\Scimore\NODES\[id] registry key, where id is the unique identifier of the server instance on the local machine (as used to differentiate server instances running on the same machine where they are installed as a Windows service). Each instance has a registry keys inside this for each category, which, in turn, contain the registry string values for the settings, eg. HKEY_LOCAL_MACHINE\SOFTWARE\Scimore\NODES\[2]\STARTUP\RECOVERY and HKEY_LOCAL_MACHINE\SOFTWARE\Scimore\NODES\[1]\NET\Endpoint. 

You can use the standard Windows regedit program to browse and change these values. 

 

Settings Overview 

Listing of accepted configuration values. Source specifies the valid sources of the setting value: either command-line option or from the windows registry. All categories and key names are case insensitive.

Category - STARTUP

Key 
Description 
Permissible Values 
Default 
Source 
CONSOLE 
This will start up the database in debugging mode with console output. 

  • 0: Normal
  • 1: Console Mode

 
0 
Command line 
INSTANCE 
Unique identifier for the server's configuration. 
Integer ?0 
Must be specified 
Command line 
MODE 
Startup mode. 

  • 0: Run
  • 1: Install New Instance
  • 2: Uninstall

 
0 
Command line 
RECOVERY 
Bit mask to specify recovery mode 

  • 1: Perform redo, if necessary
  • 2: Perform recovery, if necessary
  • 4: Continue running after recovery, regardless of errors during recovery. This is theoretically never needed. However, if redo and recovery are failing and causing scimore to not start up, specifying this bit will allow the server to run, but there may be some inconsistencies in data.

 
3 
Command line 

Category - BIN

Key 
Description 
Permissible Values 
Default 
Source 
MDump 
directory of crash dump file default 
 
 
Command line; Registry 
Bin 
Path to executables, DLLs, cluster config file, etc... 
Valid Path 
C:\Program Files\Scimore\Scimore Database Server 
Command line; Registry 

Category - NET

Key 
Description 
Permissible Values 
Default 
Source 
MaxConn 
maximum allowed connections default 
 
 
Command line; Registry 
Endpoint 
Connection string used when using NET/Mode=1. This specifies the socket to listen on. Nominally this value is specified in the sysinstances table. 
ip-address:port 
 
Command line 
Protocol 
Network protocol Id 
0: Named pipe; 1: TCP/IP 
1 
Command line; Registry 
Mode 
Network startup mode 
0: Normal cluster mode; 1: Single instance mode 
0 
Command line; Registry 

Category - TRAN

Key 
Description 
Permissible Values 
Default 
Source 
MaxLocks 
maximum allowed exlusive locks default 1048576 
 
 
Command line; Registry 
LogBlocks 
number of linked blocks (each 8Mb) in redo log file default 4 
 
 
Command line; Registry 
LogCheckpoint 
frequence in minutes of fuzzy checkpoiont default 5 
 
 
Command line; Registry 

Category - DB

Key 
Description 
Permissible Values 
Default 
Source 
SysTables 
directory for system tables default C:\scimore\data1 
 
 
Command line; Registry 
SysLog 
directory for redo log file default C:\scimore\data1 
 
 
Command line; Registry 
CachePages 
number of pages to cache default 4096 
 
 
Command line; Registry 
Data 
default directory for user defined tables default C:\scimore\data1 
 
 
Command line; Registry 

 

 

Related