sdpls {{-all| query-group-name [query-group-name...]}|-help}

This command displays information about query groups registered in the SDP server.

Administrator user

To execute this command, you need the following files:

• System configuration property file (system_config.properties)
• JavaVM options file for SDP servers (jvm_options.cfg)

working-directory\bin\

-all

Displays information about all query groups registered in the SDP server.

query-group-name [query-group-name...]

Specifies the names of the query groups whose information is to be displayed. If you specify multiple query group names, delimit their names with a single-byte space.

-help

Displays how to use the command.

If this option is specified, the command terminates without displaying stream and query group information or checking the options for errors.

• If display of all query groups specified in the argument is successful, the command returns the value 0.
• If you execute this command with multiple query group names specified and an error occurs while the command is acquiring information about one of the query groups, the command continues displaying information about the query groups that can be processed successfully. In such a case, the command returns the value 1.
• For query groups that are being registered, the command displays ----/--/-- --:--:-- as the start time. For query groups that are executing, the command displays ----/--/-- --:--:-- as the termination time.
• Once the total number of tuples stored in the stream queue exceeds the maximum value (9,223,372,036,854,775,807), the value will no longer be updated.
• Even if a query group's name is specified more than once in the argument, information about that query group is output only once.
• The total number of tuples stored in the stream queue and the maximum number of tuples retained in the stream queue are values from start to termination of the query group; these values are reset when the query group is terminated and then re-started. These values are also reset when the putEnd method is issued for all input streams in the query group. In such a case, the following values are set:
  
  • Total number of tuples stored in the stream queue: 0
  • Maximum number of tuples that can be retained in the stream queue: Number of tuples retained at the start
  • Maximum number of tuples held by the timestamp adjustment function: 0
  • Number of tuples discarded by the timestamp adjustment function: 0
• The total number of tuples stored in the stream queue includes tuples for control that are created internally. Therefore, the number of tuples displayed might be greater than the number of tuples that were sent in the following cases:
  
  • The putEnd method was issued from a custom adaptor.
  • The query group terminated normally.
• When connection is established from the input adaptor to the input stream, the number of tuples retained in the stream from the input adaptor might be displayed as the maximum and current numbers of tuples retained in the stream queue. Therefore, the displayed value might be greater than the actual tuples retained in the SDP server, such as when a retrieval of tuples from the input adaptor is delayed.

Value	Meaning
0	The command terminated normally.
1	The command resulted in an error.

Legend:

1: Displayed only when the -all option is specified.

2: Displayed for each query group.

3: Displayed for each stream registered in the query group.

4: Displayed only when the timestamp mode for the query group is DATASOURCE.

5: Displayed for each query registered in the query group.

The table below explains the variables used in the output format.

Information category	Variable	Meaning
Information output when the -all option is specified	aaaaaaaaaa	Total number of query groups (10-digit decimal number)
	bbbbbbbbbb	Total number of streams (10-digit decimal number)
	cccccccccc	Total number of queries (10-digit decimal number)
Query group information	dd...dd	Query group name
	ee...ee	Timestamp mode: DataSource: Data source mode Server: Server mode
	ff...ff	Whether or not the command can be executed in the server mode: true: Executable false: Not executable
	gggggggggg	Number of streams that belong to the group (10-digit decimal number)
	hhhhhhhhhh	Number of queries that belong to the group (10-digit decimal number)
	ii...ii	Status of the query group: Stop: Query group has terminated Running: Query group is executing Hold: Query group has shut down due to a runtime error or queue overflow FatalHold: Query group is in an unresumable status Stopping: Query group is under termination processing PreparingForStop: Tuples in the input queue are being processed or the current tuple processing is continuing, due to a query group termination request Starting: Query group is starting Deleting: Query group is being deleted Holding: Query group is being shut down
	jjjj/jj/jjjj:jj:jj	Query group start time
	kkkk/kk/kkkk:kk:kk	Query group termination time
Stream information	ll...ll	Stream name
	mm...mm	Total number of tuples stored in the stream queue (19-digit decimal number)
	nnnnnnnnnn	Number of tuples retained in the current stream queue (10-digit decimal number)
	oooooooooo	Maximum number of tuples retained in the stream queue (10-digit decimal number)
	pp...pp	Status of the timestamp adjustment function: Stop: Timestamp adjustment function is inactive Running: Timestamp adjustment function is running
	qqqqqqqqqq	Number of tuples held by the timestamp adjustment function (10-digit decimal number)
	rrrrrrrrrr	Maximum number of tuples retained by the timestamp adjustment function (10-digit decimal number)
	ssssssssss	Number of tuples discarded by the timestamp adjustment function (10-digit decimal number)
Query information	tt...tt	Query name
	uu...uu	Total number of tuples stored in the output stream queue (19-digit decimal number)
	vvvvvvvvvv	Number of tuples retained in the current output stream queue (10-digit decimal number)
	wwwwwwwwww	Maximum number of tuples retained in the output stream queue (10-digit decimal number)

Legend:

: Single-byte space