Setting Up the TWA Objects - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-10-13
dita:mapPath
awa1488824663126.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2514
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. Connect to the Teradata Database 16.00 Database using the Teradata WA (TWA) application. While connecting to the database, the TWA application checks whether the required TWA objects exist in the TDWM database or not. If they do not exist, TWA displays a prompt.


  2. Do one of the following:
    • Click Yes to create objects for TWA database operations.
    • Click No to connect to the database without creating objects.

    There is also an option to setup the TWA objects at any time by clicking Tools > twa dbs setup.

    The message prompt described above does not appear if the TDWMUpsertQualifiy procedure is present. Apart from the TDWMUpsertQualify macro, TWA uses other macros and procedures. In the absence of any required macro/procedure, TWA may encounter issues while creating and saving workloads. If such a scenario is encountered, do the following:

    1. Connect to the database and delete the procedure TDWMUpsertQualify.
    2. Run the TWA application.
    3. When prompted, click YES to create objects for TWA database operations.