This subsection provides the details of the parameters in the stream property file shown in 8.8.1(5) Specifiable parameters.
This parameter specifies a conditional expression for filtering in order to use the timestamp adjustment function to filter tuples. A specified conditional operation is performed on the contents of the column whose name is specified in the conditional expression and on a specified constant. As a result of the conditional operation, the timestamp adjustment function retains tuples satisfying the condition and discards tuples that do not satisfy the condition.
For details about how to specify the conditional expression, see 8.7.3 Coding rules for conditional expressions.
You must specify this parameter when you specify condition in the stream.filterMode parameter. If you specify unuse in the stream.filterMode parameter, this parameter is ignored, but its format is checked.
You can specify this parameter in 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):
This parameter specifies, as unuse or condition, whether the timestamp adjustment function is to be used to filter tuples. This value is not case sensitive.
If you specify unuse in the stream.timestampAccuracy parameter, this parameter is ignored, but its format is checked.
You can specify this parameter in 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):
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 specified in the system configuration property file).
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.
When the sdptplput command is used to input 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.
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 number of tuples specified in this parameter is used as the maximum value for the timestamp adjustment function for the input stream.
If the number of tuples exceeds the maximum 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 name of the stream to which the definitions in this property file are to be applied.
The specified stream name is treated as being all upper-case letters. If this parameter is omitted, an error results.
This parameter specifies the time units and time adjustment range for the timestamp adjustment function. This value is not case sensitive.
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 the name of the time-data column in tuples. This value is not case sensitive.
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 as an integer from 0 to 10 the maximum number of backup generations to be retained for the tuple log file.
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.
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).
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.
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.
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.
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.
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.
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):