sdpls (displays the status of query groups)

Format

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

Function

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

Execution permissions

Administrator user

Prerequisites for command execution

To execute this command, you need the following files:

Storage directory

working-directory\bin\

Arguments

-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.

Notes

Return value

ValueMeaning
0The command terminated normally.
1The command resulted in an error.

Output format

[Figure]

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 categoryVariableMeaning
Information output when the -all option is specifiedaaaaaaaaaaTotal number of query groups (10-digit decimal number)
bbbbbbbbbbTotal number of streams (10-digit decimal number)
ccccccccccTotal number of queries (10-digit decimal number)
Query group informationdd...ddQuery group name
ee...eeTimestamp mode:
  • DataSource: Data source mode
  • Server: Server mode
ff...ffWhether or not the command can be executed in the server mode:
  • true: Executable
  • false: Not executable
ggggggggggNumber of streams that belong to the group (10-digit decimal number)
hhhhhhhhhhNumber of queries that belong to the group (10-digit decimal number)
ii...iiStatus 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/jj[Figure]jj:jj:jjQuery group start time
kkkk/kk/kk[Figure]kk:kk:kkQuery group termination time
Stream informationll...llStream name
mm...mmTotal number of tuples stored in the stream queue (19-digit decimal number)
nnnnnnnnnnNumber of tuples retained in the current stream queue (10-digit decimal number)
ooooooooooMaximum number of tuples retained in the stream queue (10-digit decimal number)
pp...ppStatus of the timestamp adjustment function:
  • Stop: Timestamp adjustment function is inactive
  • Running: Timestamp adjustment function is running
qqqqqqqqqqNumber of tuples held by the timestamp adjustment function (10-digit decimal number)
rrrrrrrrrrMaximum number of tuples retained by the timestamp adjustment function (10-digit decimal number)
ssssssssssNumber of tuples discarded by the timestamp adjustment function (10-digit decimal number)
Query informationtt...ttQuery name
uu...uuTotal number of tuples stored in the output stream queue (19-digit decimal number)
vvvvvvvvvvNumber of tuples retained in the current output stream queue (10-digit decimal number)
wwwwwwwwwwMaximum number of tuples retained in the output stream queue (10-digit decimal number)
Legend:
[Figure]: Single-byte space