Usage Notes - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢
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