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.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

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.