16.20 - Example: Using QryLogUtilityV - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

The following SELECT statement retrieves the start time, end time, and row counts for FastLoad or TPT Load jobs submitted by USER1 since December 1, 2013:

SELECT UtilityName, LSN, JobStartTime, JobEndTime, RowsInserted
FROM DBC.QryLogUtilityV
WHERE UserName = 'USER1'
 AND (UtilityName = 'FASTLOAD' OR
      UtilityName = 'TPTLOAD')
 AND JobStartTime > DATE '2013-12-01'
ORDER BY JobStartTime;

Result:

UtilityName LSN JobStartTime               JobEndTime                 RowsInserted
----------- --- -------------------------- -------------------------- ------------
FASTLOAD    47  2013-12-02 09:19:22.150000 2013-12-02 09:30:59.670000 100,000
FASTLOAD    48  2013-12-02 09:19:24.250000 2013-12-02 09:30:44.820000 100,000
TPTLOAD     54  2013-12-02 10:07:41.700000 2013-12-02 10:07:48.940000 81,920