Capturing DBQL Using Account String - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Teradata recommends that you specify the requests to capture using DBQL in the account string, using 10 to 40 different account strings based on different system workloads. Characterize the difference between work groups using four characters that identify the work group based on workload characteristics, such as business priority. By differentiating work groups in the account string, you can report usage (such as CPU consumption) by account string. The recommended account string format is '$M00ABCD&D&H'.

Logging DBQL by account string minimizes the logging rules and avoids having to log a DBQL rule every time a user ID is created.

You cannot log use count information for account strings.