8.6.1 Details of the system configuration property file (system_config.properties)

Organization of this subsection
(1) Format
(2) File name
(3) File storage location
(4) Description
(5) Specifiable parameters

(1) Format

Specify each parameter in the following format:

parameter-name=value

(2) File name

system_config.properties

(3) File storage location

This file must be stored in the following directory:

working-directory\conf\

(4) Description

This file specifies the port number used by the SDP server and details of the API trace information and tuple logs that are to be collected. You must create this file for each working directory.

(5) Specifiable parameters

The table below lists and describes the parameters that can be specified and their default values. For details about the parameters, see 8.6.2 Details of the parameters in the system configuration property file (system_config.properties).

Table 8-4 Specifiable parameters and their default values (system_config.properties)

No.Parameter nameDescriptionDefault valuePermitted value range
1engine.initialQueueSizeSpecifies the initial number of elements used in the stream queue.1024Integer from 1 to 1048576​
2engine.maxQueueSizeSpecifies the maximum number of elements used in the stream queue.4096Integer from 1 to 1048576​
3engine.watchQueueSize.thresholdSpecifies a threshold value (%) for monitoring the number of elements used in the stream queue.NoneInteger from 1 to 99
4logger.console.abnormal.enabledSpecifies whether the SDP server start processing is to be continued in the event of a failure during log file initialization:
  • true: Outputs a message to the console and then starts the SDP server.
  • false: Shuts down the SDP server.
falsetrue
or
false
5logger.console.enabledSpecifies whether messages issued by the SDP server are to be output to the console:
  • true: Outputs messages to both log file and console.
  • false: Does not output messages to the console.
falsetrue
or
false
6mon.process_exp_timeSpecifies (in milliseconds) the processing time for determining a timeout.30000Integer from 1 to 2147483647​
7query.decimalMaxPrecisionSpecifies the maximum precision for an arithmetic operation when the result of a query is the DECIMAL type.38Integer from 1 to 38
8query.decimalRoundingModeSpecifies the rounding operation to be performed in the event the precision specified in the query.decimalMaxPrecision parameter is exceeded when the result of a query is the DECIMAL type.HALF_UPHALF_UP
or
DOWN
9querygroup.sleepOnOverStoreSpecifies the period of time that execution of a query group is to be placed in the sleep mode when the SDP server's checking determines that there is no available space in the output stream queue.1001 to 2147483647​
10querygroup.sleepOnOverStoreRetryCountSpecifies the number of times the SDP server is to check the output stream queue for available space before it loads to the output stream queue the tuples obtained from query execution.00 to 2147483647​
11rmi.serverPortSpecifies a port number for the SDP server.20400Integer from 1 to 65535
12stream.freeInputQueueSizeThresholdSpecifies a threshold value (%) for the available size with respect to the maximum number of elements used in the input stream queue.NoneInteger from 1 to 99
13stream.freeInputQueueSizeThresholdOutputMessageSpecifies whether a warning message is to be output to the SDP server's message log:
  • true: Outputs warning message.
  • false: Does not output warning message.
falsetrue
or
false
14stream.maxKeepTupleCountSpecifies the maximum number of tuples that can be retained by the timestamp adjustment function.125828Integer from 1 to 1048576​
15stream.timestampAccuracySpecifies the time units and time adjustment range for the timestamp adjustment function.NoneSee 8.6.2(15) stream.timestampAccuracy={{sec|msec|usec},time-adjustment-range|unuse}.
16stream.timestampModeSpecifies the timestamp mode used to timestamp tuples:
  • Server: Uses the server mode.
  • DataSource: Uses the data source mode.
ServerServer
or
DataSource
17stream.timestampPositionSpecifies the name of the time-data column in tuples.NoneSee 8.6.2(17) stream.timestampPosition=time-data-column-name.
18stream.tupleLogModeSpecifies whether execution of the sdptplput command is to be enabled:
  • true: sdptplput command is to be executed.
  • false: Execution of sdptplput command is to be disabled.
falsetrue
or
false
19tpl.backupFileCountSpecifies the maximum number of backup generations to be retained for the tuple log file.1Integer from 0 to 10
20tpl.bufferCountSpecifies the number of tuple log buffers.5Integer from 3 to 512
21tpl.bufferSizeSpecifies the maximum size of a tuple log buffer (in kilobytes).1024Integer from 1 to 2048000​
22tpl.fileCountSpecifies the maximum number of tuple log files.3Integer from 3 to 512
23tpl.fileSizeSpecifies the maximum size of a tuple log file (in megabytes).100Integer from 1 to 2048
24tpl.outputLevelSpecifies the tuple log output level:
  • 1: Outputs tuple logs for the tuples that are stored in the stream queue.
  • 2: Outputs tuple logs for the tuples that are discarded due to out-of-sequence time.
  • 3: Outputs tuple logs for tuples with levels 1 and 2.
3Integer from 1 to 3
25tpl.outputTriggerSpecifies the tuple log file output timing:
  • BUFFER: Outputs tuple logs to a file when the buffer being used to collect the current tuple logs in the target stream becomes full.
  • NONE: Does not output tuple logs to a file or perform buffering of tuple logs.
  • Input stream queue: BUFFER
  • Output stream queue: NONE
BUFFER
or
NONE
26tpl.useOverwriteSpecifies whether the buffer is to be overwritten in the event of a full tuple log buffer:
  • true: Overwrites the tuple log buffer.
  • false: Does not overwrite the tuple log buffer.
truetrue
or
false
27trc.api.bufferCountSpecifies the number of API trace buffers.3Integer from 3 to 512
28trc.api.bufferSizeSpecifies the maximum size of an API trace buffer (in kilobytes).1024Integer from 1 to 2048000​
29trc.api.fileCountSpecifies the maximum number of files to which API trace information is to be output.3Integer from 3 to 512
30trc.api.fileSizeSpecifies the maximum size of an API trace file (in megabytes).1024Integer from 1 to 2048
31trc.api.ioBufferSizeSpecifies the maximum size of an API trace I/O buffer (in kilobytes).2048Integer from 1 to 2048000​
32trc.api.outputTriggerSpecifies the timing for output of API trace information to a file:
  • BUFFER: Outputs API trace information to a file when the I/O thread buffer becomes full.
  • NONE: Does not output API trace information to a file or perform buffering of API trace information.
BUFFERBUFFER
or
NONE
33trc.api.useOverwriteSpecifies whether the API trace buffer is to be overwritten when the buffer becomes full:
  • true: Overwrites the API trace buffer.
  • false: Does not overwrite the API trace buffer.
truetrue
or
false