Event Types | Teradata Vantage - Event Types - Analytics Database - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Workload Management
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
aji1628112479055.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1197
Product Category
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)