16.20 - DBQL Counts DML Rows in Requests - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Release Summary

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Release Notes
featnum
B035-1098-162K

When you enable database query logging, DBQL automatically counts how many rows are updated, inserted, and deleted in a request and logs the counts in DBC.DBQLogTbl. DBQL also counts how many rows are updated, inserted, and deleted in SQL procedures, external stored procedures, Teradata Parallel Transporter, MultiLoad, and FastLoad. The StmtDMLRowCount field in DBC.QryLogV and DBC.QryLogV_sz shows the counts in JSON format. You can use JSON functions to extract data from the views.

Benefits

Tracking the amount of data manipulated for each DML request may be useful for decision-making.

Considerations

If you begin query logging using the LIMIT SUMMARY option, DBQL does not store the DML row count in DBC.DBQLogTbl.

Additional Information

For more information, see Teradata Vantageā„¢ Data Dictionary, B035-1092.