15.10 - Example: Fine Tuning Query Logging Rules - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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.”