Specify each parameter in the following format:
parameter-name=value |
query-group-name
Specify a query group name as a string of 1 to 64 alphanumeric characters (0 to 9, a to z, A to Z) and the underscore (_). A query group name must begin with a single-byte alphabetic character.
This file must be stored in the following directory:
working-directory\conf\
This file specifies the path of the query definition file and tuning parameters to be used to run the query group. You create a separate file for each query group.
The table below lists and describes the parameters that can be specified and their default values. For details about the parameters, see 8.7.2 Details of the parameters in the query group property file.
Table 8-5 Specifiable parameters and their default values (query group property file)
No. | Parameter name | Description | Default value | Permitted value range | Whether or not changeable during restart#1 |
---|---|---|---|---|---|
1 | querygroup.cqlFilePath | Specifies the path of the query definition file that defines the query group. | None | Absolute path or path relative to the working directory | N |
2 | querygroup.sleepOnOverStore | Specifies the period of time that execution of the 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. | Value specified in system_config.properties#2 | 1 to 2147483647 | Y |
3 | querygroup.sleepOnOverStoreRetryCount | Specifies 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. | Value specified in system_config.properties#2 | 0 to 2147483647 | Y |
4 | stream.filterCondition | Specifies a conditional expression for using the timestamp adjustment function to filter tuples. | None | See 8.7.2(4) stream.filterCondition=conditional-expression. | Y |
5 | stream.filterMode | Specifies whether the timestamp adjustment function is to be used to filter tuples:
| unuse | unuse or condition | Y |
6 | stream.freeInputQueueSizeThreshold | Specifies a threshold value (%) for the available size with respect to the maximum number of elements used in the input stream queue. | Value specified in system_config.properties#2 | Integer from 1 to 99 | Y |
7 | stream.freeInputQueueSizeThresholdOutputMessage | Specifies whether a warning message is to be output to the SDP server's message log:
| Value specified in system_config.properties#2 | true or false | Y |
8 | stream.maxKeepTupleCount | Specifies the maximum number of tuples that can be retained by the timestamp adjustment function. | Value specified in system_config.properties#2 | Integer from 1 to 1048576 | Y |
9 | stream.propertyFiles | Specifies the names of the stream property files when properties are specified for individual streams. | None | -- | Y |
10 | stream.timestampAccuracy | Specifies the time units and time adjustment range for the timestamp adjustment function. | Value specified in system_config.properties#2 | See 8.7.2(10) stream.timestampAccuracy={{sec|msec|usec},time-adjustment-range|unuse}. | Y |
11 | stream.timestampMode | Specifies the timestamp mode used to timestamp tuples:
| Value specified in system_config.properties#2 | Server or DataSource | N |
12 | stream.timestampPosition | Specifies the name of the time-data column in tuples. | Value specified in system_config.properties#2 | -- | Y |
13 | stream.tupleLogMode | Specifies whether execution of the sdptplput command is to be enabled:
| Value specified in system_config.properties#2 | true or false | N |
14 | tpl.backupFileCount | Specifies the maximum number of backup generations to be retained for the tuple log file. | Value specified in system_config.properties#2 | Integer from 0 to 10 | Y |
15 | tpl.bufferCount | Specifies the number of tuple log buffers. | Value specified in system_config.properties#2 | Integer from 3 to 512 | Y |
16 | tpl.bufferSize | Specifies the maximum size of a tuple log buffer (in kilobytes). | Value specified in system_config.properties#2 | Integer from 1 to 2048000 | Y |
17 | tpl.fileCount | Specifies the maximum number of tuple log files. | Value specified in system_config.properties#2 | Integer from 3 to 512 | Y |
18 | tpl.fileSize | Specifies the maximum size of a tuple log file (in megabytes). | Value specified in system_config.properties#2 | Integer from 1 to 2048 | Y |
19 | tpl.outputLevel | Specifies the tuple log output level:
| Value specified in system_config.properties#2 | Integer from 1 to 3 | Y |
20 | tpl.outputTrigger | Specifies the tuple log file output timing:
| Value specified in system_config.properties#2 | BUFFER or NONE | Y |
21 | tpl.useOverwrite | Specifies whether the buffer is to be overwritten in the event of a full tuple log buffer:
| Value specified in system_config.properties#2 | true or false | Y |