Command Line Interface Syntax - Teradata Index Wizard

Teradata Index Wizard User Guide

Product
Teradata Index Wizard
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2506
Product Category
Teradata Tools and Utilities
<command line>    ::=
tiwiz <logon specification> 
<workload details> 
[<index nametag> 
 <index analysis parameters> 
 [<restart parameters>]
]
[<gui options>]
[<output options>]
 
<logon specification> ::=[-l <tdpid>\<User Name>,<password> for CLI
 
          | -c <ODBC DSN>\<password> for ODBC
          ]
          [-am  <authentication mechanism>\<authentication parameter>]
          [-scs <session character set>]
 
<workload details> ::=
–q <QCDName> 
-w <WorkloadName> 
-id <qid1> [, <qid2>,...]
[-fr <freq1> [, <freq2>,...]]
 
<index nametag> ::= -i <IndexName>
 
<index analysis parameters> ::= <index analysis parameter> 
                 [ <index analysis parameter> ...]
<index analysis parameter> ::= -q <QCD Name>
-w <Workload Name>
-TB .<TableName>.[{,.<TableName>.}...]
-KI
-MC <number>
-MI <number>
-CR <number>
-SS <number>
-t <time Limit>
<partition Name Tag> ::= -pa <Partition Name Tag>
 
<partition analysis parameter> ::= -q <QCD Name>
-w <Workload Name>
-TB .<TableName>.[{,.<TableName>.}...]
-t <time Limit>
<restart parameters> ::= -ch <CheckPointFrequency>
<output options> ::= -o <FileName>
<gui option> ::= -g