Command-Line Switches - System Emulation Tool

Teradata System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-12
dita:mapPath
gnf1527114222337.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following table describes the command-line switches for Teradata SET. Command-line switches are not case-sensitive.

Switch Task
am Set authentication mechanism and parameter for connecting to a database.
c Connect using ODBC.
dsp Capture execution plan information for a specific date when queries are added for export using the function CURRENT_DATE. The date must be specified with this switch in mm-dd-yyyy format. For example, -dsp 02-12-2008.
ed Export by database for the specified database name.
esr Export table data used by query optimization.
This function is available only when command-line switch p (execution plans) is specified in the export options.
eqf Export by query for the queries contained in the specified file.
eqt Export by query for the query specified on the command line.
ewl Export by workload for the specified workload name.
ewr Export specific recommendation tags during an export by workload.
f Save the exported information to the specified file.
i Import information from the specified file.
icf Read the command switches from the specified file instead of the command line.
l Connect using CLIv2.
lsr Insert table data used by query optimization to tables on the test system.
qcd Export and import QCD-related information.
scs Specify session character set.
u Clean up information using the specified file.
unx Retrieve Data Dictionary information and QCD data using non-X views.
ux Retrieve Data Dictionary information and QCD data using X views.
uxq Retrieve data from the QCD using X views.
xapp Keep the application open and connected following an export, import, or undo-import (cleanup) operation. By default, the application automatically disconnects and closes after the operation completes or an unsuccessful log on occurs.
dbql Export DBQL query specified on the command line using the parameters DBQL Database name and DBQL Query ID.
tardbql Import DBQL XML Plans into the specified Target DBQL Database. The target DBQL Database name should be provided followed by the switch.
x Export execution plans in XML form for queries either entered manually (specified on the command line using switch eqt) or selected from file.

The following table describes the command-line switches for export and import options. Options can be specified in any combination and in any order. For example, typing -drs or -d -s -r achieves the same result. If no option is specified, all options are considered.

Switch Task
d Export, import, and undo object definitions.
e Export, import, and undo cost profiles. Use 't' to export current cost profiles.
g Export, import, and undo demographics.
o Export, import, and undo Optimizer cost parameters and DBS Control information.
p Export, import, and undo execution plans.
q Import and undo import the DBQL XML Plans.
r Export, import, and undo RAS.
s Export, import, and undo statistics.
w Export, import, and undo workload information, including workload definitions and index recommendations.
m Export, import and undo Maps.