16.10 - About Ending All DBQL Logging - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

Use the END QUERY LOGGING ON ALL RULES statement to eliminate all rules currently in the DBQLRuleTbl table using the ON ALL RULES option. For example:

END QUERY LOGGING ON ALL RULES;

The system will:

  • Delete rules from the DBQLRuleTbl.
  • Set the DBQLRuleCountTbl.NumberOfRules field to 0.
  • Flush all rules caches.