Account String Expansion (ASE) supports performance monitoring for account strings, enabling the system to collect AMP usage and I/O statistics.
The system stores the accumulated statistics for a user/account string pair as a row in DBC.Acctg table in the Data Dictionary. Access this information with the DBC.AMPUsageV view.
Each user/account string pair results in a new set of statistics and an additional row. You can use this information in capacity planning or in charge-back and accounting software.
At the finest granularity, ASE can generate a summary row for each SQL request. You can also direct ASE to generate a row for each user, each session, or for an aggregation of the daily activity for a user.
ASE enables you to use substitution variables to include date and time information in the account id portion of a user logon string. The system inserts actual values for the variables at Teradata SQL run time.