sdptplls (displays tuple information)
Format
sdptplls {-file tuple-log-file[ tuple-log-file...]
[-time [start-time][,end-time]] [-info {file|tuple}]
[-csv] [-data]|-file tuple-log-file
[ tuple-log-file...] -check|-help}
Function
This command displays information about the tuples collected in tuple log files.
Execution permissions
Administrator user
Prerequisites for command execution
None
Storage directory
working-directory\bin\
Arguments
-file tuple-log-file[ tuple-log-file...]
Specifies the paths of the tuple log files to be displayed.
If you specify multiple tuple log files, delimit the files with a single-byte space. In such a case, information about the specified files is displayed in the order specified.
-time [start-time][,end-time]
Specifies in the following format a start time and end time for the tuples that are to be displayed:
The start-time and end-time values are the start and end times of tuple collection. You can use this command to check the tuple collection times.
Specify start-time and end-time delimited with a comma and without any spaces.
The following describes the tuples that are displayed according to the specified time:
Note that if you specify file in the -info option, this argument is ignored.
-info {file|tuple}
Specifies the type of information to be displayed.
If you omit this argument, the command displays tuple information.
-csv
Displays the information in the CSV file format.
If you specify this option, the command treats the date and time in time information (such as a timestamp) as a single data item.
-data
Displays the contents of the tuple data objects.
If you specify file in the -info option, this option is ignored.
If you specify the -csv option, a tuple's data object that is displayed by this option is treated as a single data item.
-check
Checks the tuple log files for any erroneous tuples.
-help
Displays how to use the command.
If this option is specified, the command terminates without displaying tuple information or checking the options for errors.
Notes
If a specified tuple log file has been acquired from an environment that uses a non-default character encoding, the character string information in the tuples might not be restored correctly.
Return value
Value | Meaning |
---|---|
0 | The command terminated normally. |
1 | The command resulted in an error. |
Output format
When the -info file option is specified:
File Name : aa...aa
Version : bb-bb-bb
Query Group Name : cc...cc
Stream Name : dd...dd
Time Stamp Mode : ee...ee
Stream Type : ff...ff
Base Time : gggg/gg/gg gg:gg:gg ggg
Update Time : hhhh/hh/hh hh:hh:hh hhh
...(repeated for each file)
File Name,Version,Query Group Name,Stream Name,Time Stamp Mode,Stream Type,Base Time,Update Timeaa...aa,bb-bb-bb,cc...cc,dd...dd,ee...ee,ff...ff,gggg/gg/gg gg:gg:gg ggg,hhhh/hh/hh hh:hh:hh hhh...(repeated for each file)
The table below explains the variables used in the output format.
Variable | Meaning |
---|---|
aa...aa | Path of the tuple log file (absolute path) |
bb-bb-bb | Information about the Stream Data Platform - AF version that acquired the tuple logs |
cc...cc | Name of the query group that acquired the tuple logs (string of 1 to 64 characters) |
dd...dd | Name of the stream that acquired the tuple logs (string of 1 to 100 characters) |
ee...ee | Timestamp mode of the query group that acquired the tuple logs:
|
ff...ff | Type of stream that acquired the tuple logs:
|
gggg/gg/gg gg:gg:gg ggg | Tuple log collection reference time (year/month/day hour:minute:second millisecond) The tuple log collection reference time is the time information that is output to the tuple log file when the query group is initialized. All tuple log files with the same tuple log collection reference time become the tuple logs required for query re-execution. |
hhhh/hh/hh hh:hh:hh hhh | Update start time for the tuple log file (year/month/day hour:minute:second millisecond) |
When the -info tuple option is specified:
File Name : ii...ii
Record No Record Time Time Stamp Status
jj...jj kkkk/kk/kk kk:kk:kk kkk llll/ll/ll ll:ll:ll lll mm...mm
...(repeated for each tuple)
...(repeated for each file)
File Name : ii...ii
Record No Record Time Time Stamp Status Data
jj...jj kkkk/kk/kk kk:kk:kk kkk llll/ll/ll ll:ll:ll lll mm...mm nn...nn
...(repeated for each tuple)
...(repeated for each file)
File Name,Record No,Record Time,Time Stamp,Status
ii...ii,jj...jj,kkkk/kk/kk kk:kk:kk kkk, llll/ll/ll ll:ll:ll lll,mm...mm
...(repeated for each tuple)
...(repeated for each file)
File Name,Record No,Record Time,Time Stamp,Status,Data
ii...ii,jj...jj,kkkk/kk/kk kk:kk:kk kkk,llll/ll/ll ll:ll:ll lll,mm...mm,nn...nn
...(repeated for each tuple)
...(repeated for each file)
The table below explains the variables used in the output format.
variable | Meaning |
---|---|
ii...ii | Path of the tuple log file (absolute path) |
jj...jj | Serial number assigned to a tuple log (19-digit decimal number) |
kkkk/kk/kk kk:kk:kk kkk | Time the tuple log was acquired (year/month/day hour:minute:second millisecond) |
llll/ll/ll ll:ll:ll lll | Timestamp in the tuple (year/month/day hour:minute:second millisecond) |
mm...mm | Tuple's status:
|
nn...nn | Contents of data object ([column-1|column-2|...]) This information is displayed only when the -data option is specified. |
When the -check option is specified:
File Name : oo...oo
First No Last No
pp...pp qq...qq
Lost Norr...rr-rr...rr
...(repeated for each missing range)
...(repeated for each file)
The table below explains the variables used in the output format.
Variable | Meaning |
---|---|
oo...oo | Path of the tuple log file (absolute path) |
pp...pp | First serial number in the tuple log file (19-digit decimal number) |
qq...qq | Last serial number in the tuple log file 19-digit decimal number) |
rr...rr-rr...rr | Range of missing tuples (serial-number-of-first-missing-tuple-serial-number-of-last-missing-ruple) |