17.05 - Example: Fine Tuning Query Logging Rules - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)

Create a logging rule for myuser2 and include the WITH NONE option:

     BEGIN QUERY LOGGING WITH SQL ON ALL;
     BEGIN QUERY LOGGING WITH NONE ON myuser2 ACCOUNT='sales';

Create a logging rule for myuser2 to capture step data in DBQLStepTbl. Submit an END QUERY LOGGING request to remove the existing rule before adding the new rule:

     END QUERY LOGGING ON myuser2 ACCOUNT='sales';

This request creates the new rule:

     BEGIN QUERY LOGGING WITH STEPINFO ON myuser2 ACCOUNT='sales';

As an alternative, use a REPLACE QUERY LOGGING request instead of the END QUERY LOGGING and BEGIN QUERY LOGGING requests. See REPLACE QUERY LOGGING.