16.10 - Logging Resource Usage Data with Account String Variables - 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)

You can log resource usage data in the DBC.Acctg table by creating substitution variables in the account ID part of the user logon string. These Account String Expansion (ASE) variables let you to measure query and AMP usage more precisely. You can gather statistics for capacity planning, gather information for use in charge back and accounting, and track resource consumption.

The variables allow you to include date and time information in the string. Using ASE is a best practice. If ASE is activated, Teradata Database collects statistics based on the variables used during the active session, and stores the information into the underlying table of the DBC.AmpUsage view.