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
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
pzr1600284001549.ditamap
dita:ditavalPath
pzr1600284001549.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.