SDLEXPT(1)SDLEXPT(1)NAMEsdlexpt - A program that exports data from a logfile to an ASCII file
on the agent system
SYNOPSISsdlexpt logfile_set class [options]
DESCRIPTIONsdlexpt is an obsoleted program. The sdlexpt program's functionality
has been included in the MWA extract program. With this release you can
still run sdlexpt, but this will result in the sdlexpt command line
options being translated into extract syntax and the extract program
run to do the exporting. If you run sdlexpt with a -v option at the end
it will show you the translation. If you run sdlexpt with -V at the
end it will translate and execute the extract command. The sdlexpt
options are still documented in this manpage to help you in migrating
to the extract command line syntax.
Options-v the -v option at the end of the sdlexpt command line
will show you the translation to extract syntax.
-V the -V option at the end of the sdlexpt command line
will translate the syntax and execute the extract com‐
mands.
NOTE: the old sdlexpt options are still documented below
to help you in migrating to the extract command line
syntax. But you should discontinue using sdlexpt as
soon as possible as it will no longer be supported in
the next release.
logfile_set is the name of the logfile set where the data you want
to export is stored. If it is not in the current direc‐
tory, it must be fully qualified.
class is the class you want to export.
-b start date today [start-time]
is the first interval to export in the UNIX date format
set for this system and hh:mm format (24 hour time).
You can substitute the keyword today. Or you can sub‐
stitute the start date in mm/dd/yy format. If the time
is not specified, it is assumed to be midnight. If no
start or end options are included, all the data for the
class is exported.
-B UNIX start-time
is the first interval to export in UNIX time (seconds
since 1/1/70 00:00:00).You must use this option if you
are exporting data with the $PT_START$ variable in a
ROLL BY ACTION statement in the class specification.
-e end date today [end-time]
is the last interval to export in the UNIX date format
set for this system and hh:mm format (24 hour time). You
can substitute the keyword today. Or you can substitute
the start date in mm/dd/yy format. If the time is not
included, it is assumed to be midnight. If no start or
end options are included, all the data for the class is
exported.
-E UNIX end-time
is the last interval to export in UNIX time (seconds
since 1/1/70 00:00:00). Use this option if you are
exporting data with the $PT_END$ variable in a ROLL BY
ACTION statement in the class specification.
-f output-file is the filename to write exported data to instead of
stdout. If the name is not fully qualified, the file is
placed in the current directory. By default, headings
and blank records for intervals when no data arrived are
included if you export to a file and suppressed if you
export to stdout. Use the -h option to suppress headings
and blank records for intervals when no data arrived.
Blank records are indicated by a -1 for the record.
-h indicates that headings and blank records for intervals
when no data arrived should not be printed with exported
data. This is the default if you are exporting to std‐
out.
-H indicates that headings and blank records for intervals
when no data arrived should be printed with exported
data. This is the default if you are exporting to an
output file with the -f option. -H also converts the
date timestamp from UNIX format to mm/dd/yy/hh:mm for‐
mat.
-c separation-char
is the character to put between metrics. Enclose the
character in quotes. If you also want spaces between
metrics you should include spaces around the character.
A space is the default.
-sum seconds summarizes the data in the logfile as it is exported.
The summarization is in addition to the summarization
that was performed as the data was logged.
-shift hh:mm/hh:mm
allows you to specify in 24-hour time export of data
only between certain times (shifts). If the start time
is later than the end time, the shift is assumed to span
midnight. For example, -s 08:00/17:00 would indicate
data from 8 a.m. to 5 p.m., -s 17:00/8:00 would include
data from 5 p.m. to 8 a.m.
-we days allows you to exclude data from certain days of the
week. This option assumes the week starts with Sunday.
For example, -we 1 would exclude Sunday,and -we 17 would
exclude Sunday and Saturday.
sdlexpt-vers displays the version of this program.
sdlexpt -? displays options for this program. If your system
interprets ? as a wildcard character, use an invalid
option such as -xxx instead of -?.
SEE ALSOdsilog(1), sdlcomp(1), sdlgendata(1), sdlutil(1).
SDLEXPT(1)