Adding Exception Criteria to an Existing Workload - 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 with the previously analyzed workload with exceptions, click the Distribution Parameter option in the View By box.
  2. Right-click over the bucket row to analyzed. The Workloads Report shortcut menu for the Distribution Parameter view appears.
  3. Select Add (selected Distribution Parameter) as Exception to workload. The Add Exception to Existing WD dialog box appears.
  4. Select the options as described in the following table:
    Option Description
    Exception Name Name of the Exception parameter
    Exception Type Displays the Exception parameter to be used for the exception.
    Exception Max Value The maximum value of the selected exception parameter.
    Exception Actions No Exception Monitoring – Only log the exception.

    Continue and Log – Logs the exception and choose another action.

    Abort and Log – Log the exception and abort the request.

    Abort On Select and Log - Log the exception and abort the request only if it was a select that did not modify tables.

    Change Workload – Log the exception and move the request to the specified workload.

    Raise Alert – Log the exception and raise the specified alert through Teradata Viewpoint Alert Setup.

    Teradata Viewpoint Data Collection Service (DCS) monitors database tables and sends alerts to Teradata Viewpoint Alert Viewer for processing. Teradata Viewpoint Alert Viewer allows users to view and manage alerts.

    Run Program – Log the exception and run the specified program using Viewpoint Workload Monitor.

    For more information, see the Teradata® Viewpoint User Guide, B035-2206.

  5. Click OK. A message appears confirming the addition of the exception to the selected bucket row.
  6. Click OK. The message dialog box closes, and the selected bucket row for the exception is removed from the Distribution Report.