DBS Configuration File Keywords

Services > Service Configuration Files > Service Configuration File Keywords > DBS Configuration File Keywords

DBS Configuration File Keywords

The Database Service (DBS) is a custom service only. See Generic Database Service to set up a custom database service.

Note: The Database Service (DBS) will not appear in the CygNet Explorer service hierarchy unless it has been specifically set up.

For more information about modifying the DBS configuration file, see Service Configuration Files.

The DBS keywords are listed in the tables below:

Required Keywords
Logging Keywords
Auditing Keywords
Replication Keywords
Optional Keywords with Default Parameters
Optional Keywords with Required Parameters

Note: An asterisk in the Options column ( * ) denotes a user-defined option.

Required Keywords

Keyword	Required	Description	Default	Options
SERVICE	Yes	The name of the service in Site.Service format.	SITE.CMS	8 chars max each for site and service name; no spaces; must be unique to the system. Valid characters are: A-Z, 0-9, !, $, _
ACS	Yes	The Site and Service name of the service’s ACS, in Site.Service format.	SITE.ACS	Any valid service name of the corresponding type
TRS	Yes	The Site and Service name of the service’s TRS, in Site.Service format.	SITE.TRS	Any valid service name of the corresponding type
MSS	Yes	The Site and Service name of the MSS service from which commands will be accepted, in Site.Service format.	SITE.MSS	Any valid service name of the corresponding type
DBS_MAIN_SEC_EVENT	Yes	The main security event for this application. The value must be all uppercase, with a maximum of 8 characters.	ACCESS	Any valid security event
SVC_PORT	Yes	The UDP port number for this service. Each service on the computer must have a unique port number. Use the Config File Manager to ensure that all ports for all services on a given server are unique.	6015	5001 to 32767 (5410 can be used only by the ARS)
ACS_ID	Yes	The User ID of the service. This keyword is required for performing security events.	DBS	*

Logging Keywords

Keyword	Required	Description	Default	Options
LOGMASK_ELS	Yes	Specifies the types of service events to be logged to the associated ELS (specified in the ELS keyword). To disable logging to the ELS, comment out the ELS keyword for the selected service. See the Note below this table for more information about the keyword values. See LOGMASK_ELS in the Logging section of this Help for more information. The LOGMASK_ELS ( LMask ELS) info item will report the value of this keyword.	CONTROL EXCEPTIONS	LOG_ALL or any combination of: CONTROL EXCEPTIONS WARNING PROG_STAT MIN_TRACE
LOGMASK_FILE	Yes	Specifies the type(s) of service events to be logged to the service’s log file ([file name].log). During the current session of the service, data is written to the current log file. Log file names follow the naming convention of the selected logging mode (as set by the LOGFILE_MODE keyword value). See the Note below this table for more information about the keyword values. See LOGMASK_FILE in the Logging section of this Help for more information. The LOGMASK_FILE (LMask File) info item will report the value of this keyword.	CONTROL EXCEPTIONS WARNING	LOG_ALL or any combination of: CONTROL EXCEPTIONS WARNING PROG_STAT MIN_TRACE MAX_TRACE ENTER_EXIT
LOGFILE_FILE_COUNT	Yes	Specifies the maximum number of log files that a service will create before it starts re-using log files. For example, a count of two will produce SVC001.log, then SVC002.log, and then start back at SVC001.log, where SVC is the name of the service. Specify any value from 2 to 100. See LOGFILE_FILE_COUNT in the Logging section of this Help for more information. The LOGFILE_FILE_COUNT (File Cnt) info item will report the value of this keyword.	2	2 to 100
LOGFILE_LINE_COUNT	Yes	When the value of the LOGFILE_LIMIT_MODE keyword is LINE, this keyword specifies the maximum number of lines per log file. When the specified line count is reached, the log file is truncated at the limit point, and logging is resumed using the next available log file. Specify any value from 1000 to 1000000. See LOGFILE_LINE_COUNT in the Logging section of this Help for more information. The LOGFILE_LINE_COUNT (Line Cnt) info item will report the value of this keyword.	1000000	1000 to 1000000
LOGFILE_MODE	Yes	Specifies the operational mode for the log file, that is, how log files are maintained. Options are LEGACY or EXTENDED. The default value is LEGACY. See LOGFILE_MODE in the Logging section of this Help for more information. The LOGFILE_MODE (Logging Mode) info item will report the value of this keyword.	LEGACY	EXTENDED LEGACY
LOGFILE_LIMIT_MODE	Yes	Specifies how to limit the size of each individual log file. Options are LINE (maximum line count is determined by the LOGFILE_LINE_COUNT keyword) or SIZE (maximum file size in megabytes) determined by the LOGFILE_FILE_SIZE keyword). The default value is LINE. See LOGFILE_LIMIT_MODE in the Logging section of this Help for more information. The LOGFILE_LIMIT_MODE (Limit Mode) info item will report the value of this keyword.	LINE	LINE SIZE
LOGFILE_FILE_SIZE	Yes	When the value of the LOGFILE_LIMIT_MODE keyword is set to SIZE, this keyword specifies the maximum size (in megabytes) allowed for a log file, before logging will be continued using the next log file. Possible maximum size values are user-determined, respecting the limits of your specific system configuration. The default value is 100 megabytes. When the specified limit is reached, the log finishes the current line, closes the current file, and then continues logging in the next available log file. See LOGFILE_FILE_SIZE in the Logging section of this Help for more information. The LOGFILE_FILE_SIZE (File Size) info item will report the value of this keyword.	100 megabytes	Depends on user system configuration

Note: Use the following keyword values to set logging options for the LOGMASK_ keywords.

LOG_ALL - logs all options. This is the highest level of logging and will log everything the service is programmed to log.
CONTROL - logs control operations, such as startups, shutdowns and UIS operational events, etc.
ENTER_EXIT - logs every entry and exit through functions. This is used primarily by a programmer to debug code, and is too verbose for the ELS (not applicable for LOGMASK_ELS).
EXCEPTIONS - logs all exceptions thrown, not all of which are severe. An exception is an unexpected event occurring during execution of the service. It could be the result of a configuration error, an invalid command parameter, a bug, etc.
MAX_TRACE - more verbose logging than MIN_TRACE. This is used primarily by a programmer to debug code, and is too verbose for the ELS (not applicable for LOGMASK_ELS).
MIN_TRACE - used primarily by a programmer to debug code.
PROG_STAT - typically used to monitor the progress of the code through some logical steps. Some services, like the GNS, use it to add to the logging of the notifications, acknowledgments, and operations.
STATISTICS - enables gathering and reporting of message processing statistics.
WARNING - logs anomalies, not as serious as exceptions.

Example

A value for LOGMASK_ELS might be CONTROL + EXCEPTIONS.

A value for LOGMASK_FILE might be CONTROL + EXCEPTIONS + WARNING + PROG_STAT.

Auditing Keywords

Keyword	Required	Description	Default	Options
AUDIT_LEVEL	No	Sets auditing level of messages written to the AUD service. When set to 0, auditing is off.	1	0, 1, 2, 3,4

Replication Keywords

Keyword	Required	Description	Default	Options
CHANGE_QUEUE_SIZE	No	Sets the size of the service change queue that contains the incremental changes to the data in the source service. This is the number of changes the service will store to answer replication requests before expiring the oldest changes. Notes: This keyword is initially commented out by default. Uncomment the line and enter a valid value to use anything other than the default value. If 0 is specified, the change notification is disabled. This keyword is specified in the configuration file for the source service. The CHANGE_QUEUE_SIZE (Change Update Queue Size) info item will report configured size of the service change queue.	100000	*
REPL_SOURCE	No	Specifies the Domain and Site.Service name for the source service to be replicated. If not specified, replication is disabled. Applies to all services except ARS, FMS, and RSM. Note: This keyword is specified in the configuration file for the replicated (destination) service. The REPL_SOURCE (Repl Source Service) info item will report the source service name from which the replicated service is requesting changes. Use the Config File Manager to automatically configure this keyword for all services in your CygNet environment.	[DDDD]SITE.DBS
REPL_CHECK_INTERVAL	No	Indicates the interval (in seconds) to check before performing the next replication synchronization. This value determines the replication synchronization frequency. After performing a sync, a replicating service will subtract the amount of time the sync took from the check interval time to determine how long to wait until the next sync. For example, if the check interval is 60 seconds and the sync takes 40 seconds, the service will only wait 20 seconds before starting the next sync. If the whole sync time exceeds the frequency, then the replicating service will wait for half the sync interval (30 seconds in this case) before starting the next sync. Note: This keyword is specified in the configuration file for the replicated (destination) service. The REPL_CHECK_INTERVAL (Repl Poll Secs) info item will report the interval that a replicated service will check the source change queue for new updates. If the service is not replicating REPL_CHECK_INTERVAL will respond with an empty string.	60	1 to 3600
REPL_DELAY_MAX	No	Indicates the number of seconds a service is allowed to be behind in replication before it is considered to be behind. If this keyword is disabled, the value defaults to double the REPL_CHECK_INTERVAL time. Best practice recommends enabling and setting a meaningful value for REPL_DELAY_MAX for all replicating services. A recommended value would be a longer time interval than you would expect any sync interval to take. Note: This keyword is specified in the configuration file for the replicated service. The REPL_DELAY_MAX (Allowed repl delay) info item will report the time elapsed since the service was last fully in sync. Time is calculated as the delta between "now" and the end of the last full sync that has completed. If the time since the last successful sync exceeds the REPL_DELAY_MAX value, and the REPL_INT_VAL_STATE (Int repl val state) info item is currently "Normal", then the REPL_INT_VAL_STATE info item is set to "Delayed." The state can only be set back to "Normal" when the time between two syncs is less than the REPL_DELAY_MAX time.	120	1 to 3600
REPL_RETRY_SECS	No	Specifies the interval (in seconds) for retrying a replication update that failed. Note: This keyword is specified in the configuration file for the replicated service.	5	5 to 120
REPL_ERR_QUEUE_MAX	No	Specifies how many error entries are allowed in temporary storage. When this number is exceeded, replication processing will only process the error queue, nothing else. No new notifications will be accepted, and if a resynchronization is in progress, it will be suspended. Note: This keyword is not currently implemented.	100	10 to 500

Optional Keywords with Default Parameters

Keyword	Required	Description	Default	Options
ACS_APPLICATION	No	The service’s application name for security.	DBS	Any valid security application ID
DBS_DATABASE_FILE	No	The file name of the primary database, including the extension .dat. The service will add the extension .edb.	ServName.dat	Any valid file name with a .dat extension
DBS_INDEX_FILE	No	The file name of the primary database index, including the extension of .inx. The service will add the extension .edb.	ServName.inx	Any valid file name with a .inx extension
DBS_TEMPSTOR_FILE	No	The file name for temporary storage, including the extension .ts. The temporary storage file contains uncommitted edits. The service will add the extension .edb.	ServName.ts	Any valid file name with a .ts extension
BACKUP_TIME	No	Specifies the time for the daily backup to run (24-hour format 0000 to 2359, do not use a colon). If this keyword is not enabled for a service or no time is specified, the automatic backup will not occur. Service backup will only occur if manually initiated or scheduled via the MSS. Use the Config File Manager to automatically configure this keyword for all services in your CygNet environment.	None	0000 to 2359
DBS_LOCK_TIMEOUT	No	Sets how long (in seconds) the time locks are valid.	1800 (30 minutes)	Seconds, must be less than 5999940
MAX_CONCURRENT_MSGS	No	Sets the maximum number of concurrent messages allowed between the client and server Note: Determining the correct value for this parameter helps ensure performance efficiency. There is not one "perfect" value: setting the value too low could result in difficulties connecting to the service; setting it too high could result in eroded usage of host system memory resources. To determine the value to set for this keyword, you can assess real-time active message counts by viewing the Act Msgs value (SRVNET_ACT_MSGS (Act Msgs) info item, displayed on the Network and Service Generic pages of the CygNet Service Information dialog box), and trend the count values over time using the SVMAMSG point (SVCMON UDC, analog input type). See Trending Point Data for more information.	20	Valid values: 0 to 100 Recommended values: 10 to 100

Optional Keywords with Required Parameters

Keyword	Required	Description	Default	Options
ELS	Yes	The Site and Service name of the service’s ELS, in Site.Service format.	SITE.ELS	Any valid service of the corresponding type.
AUD	No	The Site and Service name of the service’s AUD, in Site.Service format.	SITE.AUD	Any valid service of the corresponding type.
DBS_DATADICT_FILE	No	The name of the Data Dictionary Language (.ddl) file. This keyword is required if the service name is different from the .ddl file name prefix.	None	DBSTYPE.ddl
BACKUP_PATH	No	Specifies the path to the backup directory for the service files. The path can be relative or absolute. If the path contains spaces it must be enclosed in quotation marks. The service will create the backup folder if it does not exist. Use the Config File Manager to automatically configure this keyword for all services in your CygNet environment.	None	* (path)
COPY_BACKUP_TO	No	Enables copying of the backup service files to the specified directory once the backup process is complete. The path can be relative or absolute. If the directory does not exist the service will create it. If the path or directory name contains spaces, the parameter must be enclosed in quotation marks. If you specify a network drive and are running the CygNet services as system services, you must use the Universal Naming Convention (UNC) (\\Workstation\Path) to specify the path. The backup file can be copied to a network drive only if the drive is mapped to the local machine. Use the Config File Manager to automatically configure this keyword for all services in your CygNet environment.	None	* (path)
DBS_SEC_EVENT_1	No	Secondary security event. It is used by the "navigate" event in the GRP service.	None	EventName
DBS_SEC_EVENT_2	No	Additional security event. It is used by the "navigate" event in the GRP service.	None	EventName
DBS_SEC_EVENT_3	No	Additional security event. It is used by the "navigate" event in the GRP service.	None	EventName
DBS_SEC_EVENT_4	No	Additional security event. It is used by the "navigate" event in the GRP service.	None	EventName
DBS_SEC_EVENT_5	No	Additional security event. It is used by the "navigate" event in the GRP service.	None	EventName
DBS_DISK_CACHE_IN_MEGS	No	Specifies the maximum amount of memory that the system will allocate for the disk cache in megabytes. See Buffer Cache Management for more information. The DBS_FILE_CACHE_MAX (DBS file cache max) info item will report the value of this keyword.	50	10 to 4095
DBS_MIN_DISK_CACHE_IN_MEGS	No	Specifies the minimum amount of memory that the system will allocate for the disk cache in megabytes. Controls how eager the DBS’s data cache will be to consume memory in the absence of other memory pressure in the system.	1
DBS_FILESYSTEM_CACHE_USAGE	No	Allows a DBS service to configure its database engine with a small dedicated cache and allows Windows to donate spare memory to further improve the caching of database data. See Buffer Cache Management for more information about Windows File System Cache usage. Set to ON to enable the usage of the Windows File System Cache. Set to OFF to disable the feature entirely. Set to HEURISTIC to follow the 10% model used by the DBS_DISK_CACHE_IN_MEGS keyword, described here.	HEURISTIC	OFF ON HEURISTIC
REDUNDANT	No	Indicates whether Redundancy is enabled for this service and it is part of a redundant set with other services. Set to TRUE to enable Redundancy for this service and indicate that it is in a redundant relationship with another service within the redundancy environment. Set to FALSE or commented out to disable Redundancy for this service. See Redundancy for more configuration details. A redundancy definition for your CygNet environment is configured in the CygNet Redundancy Editor. Note: A redundant RSM cannot be managed by another RSM in your redundancy environment. CygNet won’t allow an RSM to start an owned RSM if that RSM has the REDUNDANT keyword set to TRUE. The IN_REDUNDANT_SET (Service in redundant set) info item will report whether this service is part of a redundant relationship.	FALSE	TRUE, FALSE
DBS_TRANSACTION_LOG_SIZE	Yes	The size (in megabytes) of each log file in the txlogs directory. CygNet recommends using the DbsTxLogManagement utility to change the keyword. Run a backup soon after changing the size value.	5	3 to 20
DBS_TRANSACTION_LOG_DIR	No	Sets the directory where the transaction log files are stored. You cannot specify the main service directory, but it can be a subdirectory or another location. You can specify a different (faster or smaller) drive, or another location if the txlogs directory is being used for something else. The DBS_TRANSACTION_LDIR (TxLogs Folder) info item can be used to retrieve the fully qualified path. Use the Config File Manager to automatically configure this keyword for all services in your CygNet environment.	txlogs