Adding Existing Classifications to New Workloads - 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
  1. From the Analyze Workload window displaying the previously analyzed workload, click the Distribution Parameter option in the View By box. The Distribution Report displays with the selected distribution parameter by correlation parameter.
  2. Highlight the bucket to be analyzed, then right-click.

    The shortcut menu appears. See the following table for descriptions.



    Option Description
    Split to New Workload with (selected Distribution Parameter) as Classification Select this option to add a new workload with the selected distribution parameter as classification.

    This shortcut menu option displays when Result Rows, AMP Count, or Estimated Processing Time is selected from the Distribution Parameter list on the Analyze Workload tab.

    Add (selected Distribution Parameter) as classification to workload Select this option to add the selected distribution parameter as an additional criterion to the workload.

    This shortcut menu option displays when Result Rows, AMP Count or Estimated Processing Time is selected from the Distribution Parameter list on the Analyze Workload tab.

    Zoom In Select this option to change the granularity of the graph view.
    Zoom Out Select this option to change the granularity of the graph view.
    Save Report As Saves the workloads report to a file (in .xml, .txt , or .html formats).
  3. Select Split to New Workload with (selected Distribution Parameter) as Classification. The Add Workload dialog box appears. See table to complete the options. The Add Workload dialog box appears. Fields are defined in Grouping Unassigned Requests into a New Workload. Use table to complete the options.
  4. Click OK. A new workload is created from the selected workload. The new workload contains the parent workload’s classifications, along with the new criteria.