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

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.