17.00 - Resolving Simultaneous Event Detections - 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

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.