Observability - Teradata Vantage

DBQL information can be used to find and observe OTF queries. The following queries can be used to find DBQL information for OTF queries.

Feature Usage Logging Count

To find the number of OTF queries that have been run

SELECT CAST(FeatureName AS CHAR(50)) AS FEATURENAME, FEATUREUSECOUNT
FROM DBC.QryLogFeatureUseCountV
WHERE FeatureName LIKE '%OTF%' ORDER BY 2 DESC,1 ASC;

QryLogV View

For Java:

SELECT * FROM DBC.QryLogV WHERE OTFQUERY='J';

For Native:

SELECT * FROM DBC.QryLogV_SZ WHERE OTFQUERY='N';

The DBC.QryLogV view contains DBQL information for a query.

For OTF queries the value of the field OTFQUERY indicates OTF query execution method: ‘J' (java) or 'N’ (Native).

DBC.QryLogV_SZ View

For Java:

SELECT * FROM DBC.QryLogV_SZ WHERE OTFQUERY='J';

For Native:

SELECT * FROM DBC.QryLogV_SZ WHERE OTFQUERY='N'; 

The DBC.QryLogV_SZ view contains DBQL information for a query run on a DBS with Zones.

For OTF queries the value of the field OTFQUERY indicates OTF query execution method: ‘J' (Java) or 'N’ (Native).

TD_METRIC_SVC.DBQLogV View

For Java:

SELECT * FROM DBC.QryLogV_SZ WHERE OTFQUERY='J'; 

For Native:

SELECT * FROM DBC.QryLogV_SZ WHERE OTFQUERY='N'; 

The TD_METRIC_SVC.DBQLogV view contains DBQL information for a query.

For OTF queries the value of the field OTFQUERY indicates OTF query execution method: ‘J' (java) or 'N’ (Native).

TD_METRIC_SVC.DBQLog_OperationsV View

For Java:

SELECT * FROM TD_METRIC_SVC.DBQLog_OperationsV WHERE OTFQUERY='J';

For Native:

SELECT * FROM DBC.QryLogV_SZ WHERE OTFQUERY='N'; 

The TD_METRIC_SVC.DBQLog_OperationsV view contains DBQL information for a query.

For OTF queries the value of the field OTFQUERY indicates OTF query execution method: ‘J' (java) or 'N’ (Native).

PDCRINFO.DBQLogTbl View

For Java:

SELECT * FROM PDCRINFO.DBQLogTbl WHERE OTFQUERY='J';

For Native:

SELECT * FROM DBC.QryLogV_SZ WHERE OTFQUERY='N';  

The view PDCRINFO.DBQLogTbl is the same as TD_METRIC_SVC.DBQLogV and contains DBQL information for a query.

For OTF queries the value of the field OTFQUERY indicates OTF query execution method: ‘J' (java) or 'N’ (Native)

PDCRINFO.DBQLogTbl_Hst View

SELECT * FROM PDCRINFO.DBQLogTbl_Hst WHERE OTFQUERY='J';

SELECT * FROM DBC.QryLogV_SZ WHERE OTFQUERY='N';