17.10 - Warning Mode - Advanced SQL Engine - Teradata Workload Management

Teradata Vantage™ - Workload Management User Guide

Advanced SQL Engine
Teradata Workload Management
Release Number
Release Date
July 2021
Content Type
User Guide
Publication ID
English (United States)

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.