SQL Logging Statements | Teradata Vantage - SQL Logging Statements - Advanced SQL Engine - Teradata Database

When creating the necessary rules to enable SQL logging using DBQL, a rule correlates exactly to a specific SQL statement. For example, the following SQL statements show a BEGIN QUERY LOGGING statement along with its corresponding END QUERY LOGGING statement.

BEGIN QUERY LOGGING WITH SQL ON ALL ACCOUNT='$M00MSIR&D&H';
   END QUERY LOGGING WITH SQL ON ALL ACCOUNT='$M00MSIR&D&H';

The implication is that the SQL used to create the various rules should be retained so as to easily facilitate removing a rule.

The preceding account string format is considered a best practice. For more information, see Logging Resource Usage Data with Account String Variables.

All rules can be easily removed by the following command:

END QUERY LOGGING ON ALL RULES;