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:

hhmmsslll[MMDD[YYYY]]
hh: Hour (00[Figure] hh[Figure] 23)
mm: Minute (00[Figure] mm[Figure] 59)
ss: Second (00[Figure] ss[Figure] 59)
lll: Millisecond (000[Figure] lll[Figure] 999)
MM: Month (01[Figure] MM[Figure] 12)
DD: Day (01[Figure] DD[Figure] 31)
YYYY: Year (4-digit calendar year)
  • Specify this argument in single-byte numeric characters.
  • If the year is omitted from the start or end time, the command assumes the specified month, day, and time in the current year.
  • If you omit specification of year, month, and day, the command assumes the specified time on the current day, in the current month, in the current year.
  • You cannot omit only the month and day, or only the month, or only the day. If this rule is violated, an option error results.
  • If you want to omit the month or day, omit all of year, month, and day.

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

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

Output format

When the -info file option is specified:

When the -csv option is omitted:

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)

When the -csv option is specified:

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.

VariableMeaning
aa...aaPath of the tuple log file (absolute path)
bb-bb-bbInformation about the Stream Data Platform - AF version that acquired the tuple logs
cc...ccName of the query group that acquired the tuple logs (string of 1 to 64 characters)
dd...ddName of the stream that acquired the tuple logs (string of 1 to 100 characters)
ee...eeTimestamp mode of the query group that acquired the tuple logs:
  • DataSource: Data source mode
  • Server: Server mode
ff...ffType of stream that acquired the tuple logs:
  • Input: Input stream
  • Output: Output stream
gggg/gg/gg gg:gg:gg gggTuple 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 hhhUpdate start time for the tuple log file (year/month/day hour:minute:second millisecond)

When the -info tuple option is specified:

When the -csv and -data options are both omitted:

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)

When the -csv option is omitted and the -data option is specified:

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)

When the -csv option is specified and the -data option is omitted:

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)

When the -csv and -data options are both specified:

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.

variableMeaning
ii...iiPath of the tuple log file (absolute path)
jj...jjSerial number assigned to a tuple log (19-digit decimal number)
kkkk/kk/kk kk:kk:kk kkkTime the tuple log was acquired (year/month/day hour:minute:second millisecond)
llll/ll/ll ll:ll:ll lllTimestamp in the tuple (year/month/day hour:minute:second millisecond)
mm...mmTuple's status:
  • Put: Normal
  • TimeBack: Discarded due to out-of-sequence time
nn...nnContents 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.

VariableMeaning
oo...ooPath of the tuple log file (absolute path)
pp...ppFirst serial number in the tuple log file (19-digit decimal number)
qq...qqLast serial number in the tuple log file 19-digit decimal number)
rr...rr-rr...rrRange of missing tuples (serial-number-of-first-missing-tuple-serial-number-of-last-missing-ruple)