Defining or Modifying a Classification Criteria #1 for a WD - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
17.00
Published
September 2019
Language
English (United States)
Restricted Access
TTU-17.00-EAP
Last Update
2019-06-07
dita:mapPath
vjd1544831946946.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2514
Product Category
Teradata Tools and Utilities

The selection shown for Criteria #1 in the Classification tab of the Workload Attributes window automatically appears based on the criteria selected when Defining Existing Workload DBQL Inputs. For example, if you select Users for DBQL input criteria, Username appears in the Criteria #1 field of the Classification tab.

Workload Attributes Window

Depending on the DBQL input selected, the following options populate the Criteria #1 list box, identifying the “Who” of the workload:

  • Account Name
    The Account Name criteria includes the names of accounts. PG information is not included. For example, an Account Name criteria containing DBC-MANAGER only affects accounts such as $H-DBC-MANAGER and $M-DBC-MANAGER.
  • Account String
  • Application
  • Client Address

    Client Address can be specified using:

    IPv4 address format, where XXX is the range 0 to 255 decimal:

    XXX.XXX.XXX.XXX
    • Client ID (for logon)
  • Profile
  • Username
  • Include QueryBand and Exclude QueryBand