End All DBQL Logging | Teradata Vantage - Ending All DBQL Logging - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

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.