16.10 - Feature Use Logging - Teradata Database

Teradata Database Release Summary

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Release Notes
featnum
B035-1098-161K

Provides the ability to log database feature use information.

Feature Use Logging captures information about the various Teradata Database features that a particular query uses. You can use this information, for example, to determine which features are used most often. Feature use information is logged in the FeatureUsage column of DBC.DBQLogTbl.

Benefits

  • Provides the ability to identify the most commonly used features. To display current use count information, you can access DBC.QryLogFeatureUseCountV and the binary data in the FeatureUsage column of DBC.DBQLogTbl. The use count information is based on number of rows in DBC.DBQLogTbl.
  • Feature Use Logging data is available for all requests, whether the requests are cached or not cached.

Considerations

  • Captures features only from the PE (Parsing Engine), not features only visible on an AMP. To display the current list of features being logged, you can use this statement:
    SELECT featurename FROM DBC.QryLogFeatureListV;
  • The FeatureUsage column stores usage information in binary format. You can use the TD_DBQLFUL table function to convert the binary data into a JSON document. To display feature use information in JSON format, you can access the FeatureInfo column of the QryLogFeatureJSON view.
  • Feature use logging tracks database feature usage, not the utilities or external tools such as third party applications using database features. Certain features also provide common functionality that is used in a variety of operations.

SQL Changes

  • BEGIN QUERY LOGGING statement, FEATUREINFO option.
  • REPLACE QUERY LOGGING statement, FEATUREINFO option.
  • Show Query Logging statement, FeatureUsage option status.

Additional Information

For more information on Feature Use Logging, see:
  • Database Administration
  • SQL Data Definition Language - Syntax and Examples
  • SQL Functions, Operators, Expressions, and Predicates
  • Data Dictionary