Event Types | Teradata Vantage - 17.00 - Event Types - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

prodname
Advanced SQL Engine
Teradata Workload Management
vrm_release
17.00
created_date
June 2020
category
Administration
User Guide
featnum
B035-1197-170K
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)