This subsection provides the details of the parameters in the system configuration property file (system_config.properties) shown in 8.6.1(5) Specifiable parameters.
This parameter specifies as an integer from 1 to 1048576 the initial number of elements used in the stream queue. The default value is 1024.
If you attempt to register more elements in the stream queue than specified here, the stream queue is extended up to the maximum value specified in the engine.maxQueueSize parameter.
Note that the initial number of elements specified here becomes the initial value for each stream queue.
This parameter specifies as an integer from 1 to 1048576 the maximum number of elements used in the stream queue. The default is 4096.
Make sure that the maximum number of elements used in the stream queue is no greater than the initial number of elements specified in the engine.initialQueueSize parameter.
Note that the maximum number of elements specified here becomes the maximum value for each stream queue.
This parameter specifies the threshold value (%) for monitoring the number of elements used in the stream queue as an integer from 1 to 99. If this parameter is omitted, the number of elements is not monitored.
If the value obtained from the formula shown below is greater than the value of this parameter, a warning message is output.
Number of elements![]() |
Once this warning message is output, it will not be output again until the next time the number of elements exceeds the threshold value after it dropped below the threshold value.
This parameter specifies, as true or false, whether the SDP server start processing is to be continued in the event of a failure during log file initialization. This value is not case sensitive. The default value is false.
This parameter specifies, as true or false, whether messages issued by the SDP server are to be output to the console. This value is not case sensitive. The default value is false.
This parameter specifies (in milliseconds) the amount of time used for processing before a timeout occurs, as an integer from 1 to 2147483647. The default value is 30000.
If use of the default value results in frequent output of a timeout detection message, specify an appropriate value on the basis of the actual processing time that is needed, as obtained from the API trace information.
This parameter specifies as an integer from 1 to 38 the maximum precision for an arithmetic operation when the result of a query is the DECIMAL type (including the NUMERIC type). The default value is 38.
The following arithmetic operations result in the DECIMAL type:
If the result of an arithmetic operation does not exceed the precision specified in this parameter, precision processing is not processed. If the result of an arithmetic operation exceeds the precision specified in this parameter, the result is rounded to the precision specified in this parameter. You use the query.decimalRoundingMode parameter to specify the rounding operation to be applied.
This parameter specifies 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 (including the NUMERIC type). The default value is HALF_UP.
This parameter specifies as an integer from 1 to 2147483647 the period of time (in milliseconds) 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. The default value is 100.
This parameter takes effect if 1 or a greater value is specified in the querygroup.sleepOnOverStoreRetryCount parameter.
You can perform the following operations on a query group that has been placed in the sleep mode by this parameter:
You can specify this parameter in the system configuration property file and the query group property file. If the parameter is duplicated or omitted, the specified value takes effect in the following order (1 > 2):
This parameter specifies as an integer from 0 to 2147483647 the number of times the SDP server is to check the output stream queue for available space before it loads the tuples obtained from query execution to the output stream queue. The default value is 0.
If the value 0 is specified, the SDP server loads the tuples obtained from query execution to the output stream queue without checking the output stream queue for available space.
If 1 or a greater value is specified, the SDP server performs the following processing as many times as specified:
You can specify this parameter in the system configuration property file and the query group property file. If the parameter is duplicated or omitted, the specified value takes effect in the following order (1 > 2):
This parameter specifies a port number for the SDP server, as an integer from 1 to 65535. The default value is 20400.
If the default port number (20400) is being used as a port number in another system, you must specify a different port number. We recommend that you do not use port numbers 1 through 1023 (because they are commonly-used port numbers).
This parameter specifies a threshold value (%) for the available size with respect to the maximum number of elements used in the input stream queue as an integer from 1 to 99 (the engine.maxQueueSize parameter value).
When the condition shown below is satisfied, a SDPClientFreeInputQueueSizeThresholdOverException exception is thrown from the put(StreamTuple tuple) method or the put(ArrayList<StreamTuple> tuple_list) method. In such a case, loading of tuples into the input stream queue has been successful.
This parameter's value![]() ![]() |
If this parameter is omitted, an exception by threshold value checking will not occur.
Note that the engine.watchQueueSize.threshold parameter specifies a threshold value for the usage size compared to the maximum size of input and output stream queues. It is different from the stream.freeInputQueueSizeThreshold parameter. For details, see the engine.watchQueueSize.threshold parameter.
When the sdptplput command is used to load tuples to the input stream queue, this parameter is ignored.
You can specify this parameter in the system configuration property file, the query group property file, and the stream property file. If the parameter is duplicated or omitted, the specified value takes effect in the following order (1 > 2 > 3):
This parameter specifies, as true or false, whether a warning message (the KFSP42032-W message) is to be output to the SDP server's message log. This value is not case sensitive. The default value is false.
This parameter takes effect only when the stream.freeInputQueueSizeThreshold parameter is specified.
Note that the warning message is output only when true is specified in this parameter and the following condition is satisfied:
stream.freeInputQueueSizeThreshold parameter value![]() ![]() |
You can specify this parameter in the system configuration property file, the query group property file, and the stream property file. If the parameter is duplicated or omitted, the specified value takes effect in the following order (1 > 2 > 3):
This parameter specifies as an integer from 1 to 1048576 the maximum number of tuples that can be retained by the timestamp adjustment function. The default value is 125828.
The number of tuples specified in this parameter is used as the maximum value for the timestamp adjustment function for each input stream.
When the number of tuples exceeds the value specified in this parameter, the query group is shut down.
You can specify this parameter in the system configuration property file, the query group property file, and the stream property file. If the parameter is duplicated or omitted, the specified value takes effect in the following order (1 > 2 > 3):
This parameter specifies the time units and the time adjustment range for the timestamp adjustment function. This value is not case sensitive.
You must specify this parameter when you specify DataSource in the stream.timestampMode parameter. If you specify Server in the stream.timestampMode parameter, this parameter is ignored, but its format is checked.
Time units | Permitted value range |
---|---|
sec (seconds) | Integer from 0 to 59 |
msec (milliseconds) | Integer from 0 to 999 |
usec (microseconds) | Integer from 0 to 999 |
You can specify this parameter in the system configuration property file, the query group property file, and the stream property file. If the parameter is duplicated or omitted, the specified value takes effect in the following order (1 > 2 > 3):
This parameter specifies Server or DataSource as the timestamp mode to be used in timestamping tuples. This value is not case sensitive. The default value is Server.
You can specify this parameter in the system configuration property file and the query group property file. If the parameter is duplicated or omitted, the specified value takes effect in the following order (1 > 2):
This parameter specifies the name of the time-data column in tuples. This value is not case sensitive.
If you specify DataSource in the stream.timestampMode parameter, you must also specify this parameter. If you specify Server in the stream.timestampMode parameter, this parameter is ignored, but its format is checked.
The only data type that can be specified as time data is the TIMESTAMP type.
The permitted range of time data is from 1970/01/01 00:00:00.000000000 to 2261/12/31 23:59:59.999999999 in GMT (Greenwich Mean Time). If a specified time is outside this range, an exception occurs when the stream data is sent.
You can specify this parameter in the system configuration property file, the query group property file, and the stream property file. If the parameter is duplicated or omitted, the specified value takes effect in the following order (1 > 2 > 3):
This parameter specifies whether execution of the sdptplput command is to be enabled. This value is not case sensitive. The default value is false.
If you specify Server in the stream.timestampMode parameter and true in this parameter, an SDPClientException exception will occur if you then send stream data using the put method of the StreamInput interface.
You can specify this parameter in the system configuration property file and the query group property file. If the parameter is duplicated or omitted, the specified value takes effect in the following order (1 > 2):
This parameter specifies as an integer from 0 to 10 the maximum number of backup generations to be retained for the tuple log file. The default value is 1.
You can specify this parameter in the system configuration property file, the query group property file, and the stream property file. If the parameter is duplicated or omitted, the specified value takes effect in the following order (1 > 2 > 3):
This parameter specifies the number of tuple log buffers, as an integer from 3 to 512. The default value is 5.
You can specify this parameter in the system configuration property file, the query group property file, and the stream property file. If the parameter is duplicated or omitted, the specified value takes effect in the following order (1 > 2 > 3):
This parameter specifies as an integer from 1 to 2048000 the maximum size of a tuple log buffer (in kilobytes). The default value is 1024.
You can specify this parameter in the system configuration property file, the query group property file, and the stream property file. If the parameter is duplicated or omitted, the specified value takes effect in the following order (1 > 2 > 3):
This parameter specifies the maximum number of tuple log files, as an integer from 3 to 512. The default value is 3.
You can specify this parameter in the system configuration property file, the query group property file, and the stream property file. If the parameter is duplicated or omitted, the specified value takes effect in the following order (1 > 2 > 3):
This parameter specifies the maximum size of a tuple log file (in megabytes), as an integer from 1 to 2048. The default value is 100.
You can specify this parameter in the system configuration property file, the query group property file, and the stream property file. If the parameter is duplicated or omitted, the specified value takes effect in the following order (1 > 2 > 3):
This parameter specifies the tuple log output level, as an integer from 1 to 3. The default value is 3.
You can specify this parameter in the system configuration property file, the query group property file, and the stream property file. If the parameter is duplicated or omitted, the specified value takes effect in the following order (1 > 2 > 3):
This parameter specifies BUFFER or NONE as the tuple log file output timing. This value is not case sensitive. The default value is BUFFER for input stream queues and NONE for output stream queues.
You can specify this parameter in the system configuration property file, the query group property file, and the stream property file. If the parameter is duplicated or omitted, the specified value takes effect in the following order (1 > 2 > 3):
This parameter specifies, as true or false, whether a tuple log buffer is to be overwritten in the event it becomes full. This value is not case sensitive. The default value is true.
You can specify this parameter in the system configuration property file, the query group property file, and the stream property file. If the parameter is duplicated or omitted, the specified value takes effect in the following order (1 > 2 > 3):
This parameter specifies the number of API trace buffers, as an integer from 3 to 512. The default value is 3.
This parameter specifies the maximum size of an API trace buffer (in kilobytes), as an integer from 1 to 2048000. The default value is 1024.
This parameter specifies as an integer from 3 to 512 the maximum number of files to which API trace information is to be output. The default value is 3.
This parameter specifies the maximum size of an API trace file (in megabytes), as an integer from 1 to 2048. The default value is 1024.
This parameter specifies the maximum size of an API trace I/O buffer (in kilobytes), as an integer from 1 to 2048000. The default value is 2048.
This parameter specifies BUFFER or NONE as the timing for output to file of API trace information. This value is not case sensitive. The default value is BUFFER.
This parameter specifies, as true or false, whether the API trace buffer is to be overwritten when the buffer becomes full. This value is not case sensitive. The default value is true.