The predefined DBQL logs are created as relational tables in DBC during normal Vantage installation.
By default on VantageCloud Lake, Detailed logging is enabled. For users or accounts running tactical workloads, Teradata recommends enabling DBQL Summary/Threshold logging to make the logging volume nominal. The summary log can be accessed using dbqlsummaryV .
The default mode for DBQL logging is set to Algorithm 3.
AMPs use a DBQL cache called DBQL Performance Stats (DPS) cache. The default cache size is 8192.
If you choose not to use DBQL logging, the tables remain empty.