Defining Exception Actions - 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
  • Under Exception Actions, select the appropriate fields/controls. You must specify at least one exception criteria to access these controls.
    Exception Action Fields/Controls 
    Field/Control Action/Comment
    No Exception Monitoring Select this control to prevent logging.

    This control temporarily disables the exception directive without deleting it.

    Continue and Log Select this control to log the exception and choose another action.

    If you select this option, you can select Change Workload, Raise Alert, and Run Program.

    Change Workload
    1. Select Continue and Log.

      Change Workload is only available with Continue and Log.

    2. Select Change Workload.
    3. Select the WD in the list box to log the exception and move the request to the specified WD.

      If you specify a positive value for Tactical CPU Usage Threshold (per node), you must specify Change Workload and another WD mapped to an AG in the same RP as one of the exception actions.

    All exceptions in the same operating environment with Tactical CPU Usage Threshold (per node) must use the same value and have the same WD in a Change Workload exception action.

    If you specified values for Blocked Time, Elapsed Time, or both, Change Workload is not an option as an exception action.

    When specifying Change Workload as the exception action that is not to be applied to all operating environments, the following warning will display:

    By not applying an Exception with a Change Workload action to all operating Environments, a request may not consistently route to the same final Workload across different Operating Environments. This may lead to misleading or confusing workload accounting.

    You may not specify Change Workload for the default workload (WD-default).

    Raise Alert
    1. Select Continue and Log, Abort and Log, or Abort on Select and Log to access Raise Alert.
    2. Select Raise Alert to log the exception and raise an alert.
    3. Enter the name of the alert configured using Teradata Viewpoint Alert Setup.
    Run Program
    1. Select Continue and Log, Abort and Log, or Abort on Select and Log to access Run Program.
    2. Select Run Program to log the exception and run a program.

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

    Post to Queue Table
    1. Select Continue and Log, Abort and Log, or Abort on Select and Log to access Post to Queue Table.
    2. Select Post to Queue Table to log to the DBC.SystemQtbl table. Note that the Query ID is recorded and can be used to connect information from the TDWMExceptionLog and the DBQLSqlTbl.
    3. [Optional] Enter a comment (maximum 120 characters) in the text box.
    Abort and Log Select this control to log the exception and abort the request.

    When you select this option, Raise Alert and Run Program are enabled.

    Abort on Select and Log Select this control to log the exception and abort the request if it contains only SELECT statement(s) and the current transaction has not executed any UPDATE, DELETE, or INSERT statements. Otherwise, select Continue and Log.

    When you select this option, Raise Alert and Run Program are enabled.