17.10 - Resolving Simultaneous Event Detections - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.10
Release Date
July 2021
Content Type
Administration
User Guide
Publication ID
B035-1197-171K
Language
English (United States)

You can create multiple events of the same type but with different threshold values. For example, you could create an Available AWTs event with a threshold of less than 20 and a second Available AWTs event with a threshold of less than 10. When TASM evaluates the events at the end of an event interval, and the available AWTs are 5, both defined events are activated. TASM performs all event actions. For an example of a state matrix with different planned environments and health conditions, see the figure in State Matrix Basics.

If events activate multiple planned environments or health conditions, TASM determines the active state by planned environment precedence and health condition severity. For example, the state matrix has 3 health conditions, in order of highest to lowest severity: Red, Yellow, and Normal. If < 20 Available AWTs triggers a change to health condition Yellow and < 10 Available AWTs triggers a change to health condition Red, the Red health condition takes precedence and the state changes to the one associated with Red.