15.00 - Command-Line Switches - System Emulation Tool

Teradata System Emulation Tool User Guide

prodname
System Emulation Tool
vrm_release
15.00
category
User Guide
featnum
B035-2492-034K

Command‑Line Switches

Table 7 describes the command‑line switches for Teradata Set. Command‑line switches are not case‑sensitive.

 

Table 7: Command‑Line Switches 

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.

Note: 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.

Table 8 describes the command‑line switches specifically 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.

 

Table 8: Command‑Line Switches for Export and Import Options 

Switch

Task

d

Export, import, and undo object definitions.

e

Export, import, and undo 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.