17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)
This view contains entries for:
  1. Logons rejected due to the Teradata dynamic workload management software throttle limits
  2. Queries rejected due to the Teradata dynamic workload management software object access violations
  3. Queries rejected due to the Teradata dynamic workload management software throttle limits if abort option is chosen
  4. Queries subject to WD exception handling

For more information about the possible values for the ExceptionValue column, see "ExceptionValue Column."

Possible Values for ExceptionAction

Value Description
A Abort. Cannot be combined with other actions.
C Change workload definition (WD). NewWlcId contains the new WD.
L Log.
E Execute Program. ExProgram contains the program name.
T Alert. ExAlert contains the alert name.
N No action. This option cannot be combined with other actions and disables exception detection.
S Abort if the statement is a SELECT and no update has been done in the current (user) transaction.
Q Post to queue table.

Possible Values for RejectionCat

Value Description
1 A rejection due to a TASM Filter rule
2 A rejection due to a TASM Throttle rule
3 A rejection due to a TASM Workload rule