17.00 - Usage Notes - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K
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