15.10 - ALL 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

Logging rules are removed from DBC.DBQLRuleTbl and the rules cache. Logging based on those rules is discontinued.

Example: Remove all DBQL rules in effect from DBC.DBQLRuleTbl

To remove all DBQL rules in effect from DBC.DBQLRuleTbl and update all active sessions to remove any DBQL logging at the next request, submit this request.

     END QUERY LOGGING ON ALL RULES;