16.10 - JSON View of the DBQLogTbl Feature Usage Column: QryLogFeatureUseJSON[V] - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

QryLogFeatureUseJSON[V] provides a view into the FeatureUsage column of DBQLogTbl. This view uses the system function TD_SYSFNLIB.TD_DBQLFUL to convert the FeatureUsage bitmap column into a JSON document with a list of features used by particular requests. The names of the used features are shown in JSON format. For details on the system function TD_SYSFNLIB.TD_DBQLFUL, see SQL Functions, Operators, Expressions, and Predicates.

The following table describes the fields in QryLogFeatureUseJSON[V].
QryLogFeatureUseJSON[V] Field Description
QueryID Internally generated identifier of the query and the FK to other DBQL tables.
QueryID is a system-wide unique field; You can use QueryID to join DBQL tables or the DBC.TdwmExceptionLog table with DBQL tables without needing ProcID as an additional join field.
FeatureUsage List of the features used, in JSON format.