Usage Notes - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
muh1623078990997.ditamap
dita:ditavalPath
muh1623078990997.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