Utility Job Performance Analysis | Teradata Vantage - Utility Job Performance Analysis and Capacity Planning - Advanced SQL Engine - Teradata Database

Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
upb1600054424724.ditamap
dita:ditavalPath
upb1600054424724.ditaval
dita:id
B035-1093
lifecycle
previous
Product Category
Teradata Vantageā„¢

You can query the DBQL utility job log table, DBC.DBQLUtilityTbl, to analyze the performance of load or export utility jobs and do capacity planning. This table is populated if you use the WITH UTILITYINFO option with a BEGIN/REPLACE QUERY LOGGING request. For details on the contents of the corresponding view QryLogUtility[V], see Teradata Vantageā„¢ - Data Dictionary, B035-1092 and Maximum Number of Concurrent FastLoad, MultiLoad, and FastExport Jobs.