16.10 - Warning Mode - Teradata Workload Management

Teradata Database Workload Management User Guide

Teradata Workload Management
June 2017
User Guide

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.