sdptrced (edits trace information)

Format

sdptrced {-file trace-file-name[ trace-file-name...]
         [-time [start-time][,end-time]]
         [-threadid thread-ID[ thread-ID...]] [-csv]|-help}

Function

This command edits and outputs API trace information.

Execution permissions

Administrator user

Prerequisites for command execution

To execute this command, you need the following files:

Storage directory

working-directory\bin\

Arguments

-file trace-file-name[ trace-file-name...]

Specifies the absolute path names of the trace files to be edited. When you specify multiple trace file names, delimit the file names with a single-byte space.

-time [start-time][,end-time]

Specifies in the following format a start time and end time for the trace information that is to be output:

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.

Specify start-time and end-time delimited with a comma and without any spaces.

The following describes the trace information that is displayed according to the specified time:

-threadid thread-ID[ thread-ID...]

Outputs only that trace information that was output by threads with the specified thread IDs.

Express a thread ID in single-byte numeric characters. The permitted value range is from 0 to 9223372036854775807. To specify multiple thread IDs, delimit them with the single-byte space.

-csv

Displays the trace information editing results in the CSV file format.

-help

Displays how to use the command.

If this option is specified, the command terminates without outputting trace information or checking the options for errors.

Notes

Return value

ValueMeaning
0The command terminated normally.
1The command terminated abnormally.

Output format

The output format is shown below. For an example of the output, see 6.3.2 Details of API trace information.

When the -csv option is omitted:

Ver       Kind  File
aa-aa-aa  bbb   cc...cc
Date       Time     nSec      Current         Parent          Root            EventID
dddd/dd/dd ee:ee:ee fffffffff gg...gg-hh...hh ii...ii-jj...jj kk...kk-ll...ll 0xmmmmmmmm
Rc        Data
noo...oo  pp...pp

When the -csv option is specified:

Ver,Kind,File
aa-aa-aa,bbb,cc...cc
Date,Time,nSec,Current,Parent,Root,EventID,Rc,Data
dddd/dd/dd,ee:ee:ee,fffffffff,gg...gg-hh...hh,ii...ii-jj...jj,kk...kk-ll...ll,0xmmmmmmmm,
noo...oo,pp...pp

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

VariableMeaning
aa-aa-aaInformation about the Stream Data Platform - AF version used to output the trace files
bbbType of trace files:
  • API: API trace information files
  • None: Other than Stream Data Platform - AF trace files
cc...ccPath (absolute path) of the trace file
dddd/dd/ddTrace output date (year/month/day)
ee:ee:eeTrace output time (hour:minute:second)
fffffffffTrace output time nanosecond (9-digit decimal number)
gg...gg-hh...hhSerial number assigned to this trace (thread ID (19-digit decimal number) -processing serial number (10-digit decimal number))
ii...ii-jj...jj#Reserved area.
This information is output in the format 19-digit-decimal-number-10-digit-decimal-number.
kk...kk-ll...llSerial number assigned to the trace start point (thread ID (19-digit decimal number) -processing serial number (10-digit decimal number))
The trace start point is the time at which the tuple handled by the process that collected this trace was input (or generated within a query). Traces with the same serial number constitute a series of processing on the same tuple.
mmmmmmmmEvent ID (8-digit hexadecimal number):
  • 0x00020000​: Query processing (input of tuples)
  • 0x00020001​: Query processing (output of tuples)
noo...oo#Reserved area
n indicates the sign part. This information is output as an 11-digit decimal number. A single-byte space is displayed in n.
pp...ppName of query that collected trace information (first 32 bytes of the query name)
#
In Stream Data Platform - AF 01-00, a single-byte space plus 10 digits of zeros are output.