Event Types | Teradata Vantage - Event Types - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
nbl1556236178169.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1197
lifecycle
previous
Product Category
Software
Teradata Vantage
The following table shows the types of events that TASM can detect either individually or in combination.
Class Subclass Description
Planned Events
You can combine multiple events. Event combinations can trigger the same actions as individual events.
Period Event Frequency and Duration can include these user-specified time periods:
  • Day of Week
  • Day of Month and Month of Year

TASM monitors the system time and automatically triggers an event when the period starts. The event persists until the period ends.

User-defined These events can be activated at any time through an API. They last until the DBA rescinds them or until they time out.
Unplanned Events
You can combine multiple events. Event combinations can trigger the same actions as individual events.
System System Events can be triggered by any of the following criteria:
  • Node Down (user-specified percent of clique)
  • AMP Fatal (limit)
  • Available AWTs (number in user-specified qualification period)
  • Gateway Fatal (limit)
  • PE Fatal (limit)
  • Flow Control (number of AMPs in user-specified qualification period)
  • I/O Usage (percent in user-specified qualification period)
  • CPU Utilization (percent in user-specified qualification period)
  • CPU Skew (percent in user-specified qualification period)
When TASM detects this type of event, it keeps the event active until the component is restored or the resource value returns to normal for a predetermined time.
User-defined These events can be activated at any time through an API. They last until the DBA rescinds them or until they time out.
Workload Workload Events can be triggered by any of the following user-specified criteria:
  • Active requests (number per user-specified qualification period)
  • Arrivals (of requests) at a user-specified rate
  • AWT Wait Time (number of user-specified seconds per qualification period)
  • CPU Utilization (as a percentage per qualification period)
  • Delay Queue Depth (number of queries in the delay queue)
  • Delay Queue Time (in hours, minutes, or seconds)