Warning Mode - 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

When you create a filter, you can choose Warning Only mode for initial implementation. This mode returns a warning message when the filter affects a request instead of rejecting the request, so you can determine how the filter is functioning without disrupting users. Requests that match filter criteria are logged in DBQLogTbl, with the “WarningOnly” field set to “T.” Once you determine that the filter is working as planned, you can turn off Warning Only mode and allow TASM to reject affected queries.

Tip: Teradata recommends that you place a new filter in Warning Only mode for 1-2 weeks so that you can predict how many requests the filter will affect when it goes live. The Warning Only period also gives you time to work with users who may not realize that they are submitting poorly performing requests.