Use the command line interface to export information for a specified workload. This is useful for extracting the information required to perform an index analysis on a test system using Teradata Index Wizard. You must specify the workload name and the name of the QCD that contains the workload.
-
Use the following command syntax to export by workload:
tset [-icf <commandfile> ]| [[-c|-l] <DSN_or_tdpid>\<username>\<password> [-am <Authentication Mechanism>\<Authentication Parameter>] [-scs <Session characterset>] -qcd <qcdname> -ewl <workloadname> [-ewr <recommendationtag1> [-ewr <recommendationtag2> ... ]] [-f <exportfile>] [-d -s -r -p -o -g -w -e -m] [-xapp]]
The following example demonstrates how to export by workload from the command line. Type:
tset -l prod\dbc\dbc -qcd qcd -ewl wl1 -dsrpow -f workload1
Object definitions, statistics, and RAS for the objects referenced by the queries of workload wl1 in the QCD named qcd from the system prod are exported. The execution plans for the queries, the workload definition, plus any index recommendations and cost parameters are also exported. This is all of the information needed to do an index analysis on a test system using Teradata Index Wizard. The exported data is saved to a file named workload1.