17.00 - Usage Notes - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

Only users with DBC or SystemFE privileges are able to use this view.

LockDelay

The LockDelay column returns the minimum elapsed time of a lock contention in centiseconds. Any lock contention greater than this time will be recorded in the DBC.DBQLXMLLockTbl table as specified in the BEGIN QUERY LOGGING WITH LOCK statement. The minimum LockDelay value is 5 centiseconds.

Possible Values for DetailedStats

Value Description
T Detailed statistics are provided.
F Detailed statistics are not provided.

Possible Values for ExplainFlag

Value Description
T EXPLAIN text is logged.
F EXPLAIN text is not provided.

Possible Values for FeatureUsage

Value Description
T Feature usage information is collected.
F Feature usage information is not collected.

Possible Values for NoColumns

The NoColumns column indicates if columns are logged as part of object logging. When query logging is enabled with the OBJECTS option, a separate row for each table and column referenced is added to the DBQL object table. With NoColumns set to T, the columns are not logged.

Value Description
T Query logging is enabled without column logging.
F Query logging is enabled with column logging.

Possible Values for ParamFlag

ParamFlag shows whether parameters and values are stored for parameterized requests.

Value Description
T Query parameters and values are logged.
F Query parameters and values are not logged.

Possible Values for ObjFlag

ObjFlag shows whether data (columns and indexes) are stored.

Value Description
T Object data is logged.
F Object data is not logged.

Possible Values for ObjectUsage

Value Description
T Object use counts are logged.
F Object use counts are not logged.

Possible Values for SQLFlag

Value Description
T SQL text is logged.
F SQL text is not provided.

Possible Values for StatsUsageFlag

Value Description
T Statistics usage is logged.
F Statistics usage is not logged.

Possible Values for StepFlag

Value Description
T Step-level data is logged.
F Step-level data is not provided.

Possible Values for SummaryFlag

Value Description
T Summary information is logged.
F Summary information is not provided.

Possible Values for ThresholdFlag

Value Description
T Counts the queries that are shorter or equal to SummaryVal1 in DBC.DBQLSummaryTbl. Provides detailed data on longer queries in DBC.DBQLogTbl.
F Provides detailed data for all queries in DBC.DBQLogTbl unless the SummaryFlag is True.

Possible Values for TypeOfCriterion

Value Description
0 ElapsedSec (Elapsed seconds)
1 CPUTime (CPU time in centiseconds)
2 IOCount (I/O count)
3 CPUTimeNorm (Normalized CPU time in centiseconds for coexistence systems)
4 ElapsedTime (Elapsed time in centiseconds)
5 No logging criterion.

Possible Values for TypeOfRule

  • Logging enabled
  • WITH NONE (No logging)

Possible Values for UtilityInfoFlag

Value Description
T TASM utility statistics are logged.
F TASM utility statistics are not logged.

Possible Values for Verbose

Value Description
T Verbose EXPLAIN and related information in XML format are provided.
F Verbose EXPLAIN and related information in XML format are not provided.

Possible Values for XMLPlanFlag

Value Description
T XML query plans are logged.
F XML query plans are not logged.

SummaryVal1, SummaryVal2, and SummaryVal3

Column Description
SummaryVal1 Returns the high value for interval 1 if the SummaryFlag or ThresholdFlag columns are T.

This value can be in seconds, CPU centiseconds, or I/Os.

SummaryVal2 Returns the high value for interval 2 if the SummaryFlag or ThresholdFlag columns are T.

This value can be in seconds, CPU centiseconds, or I/Os (see TypeOfCriterion).

SummaryVal3 Returns the high value for interval 3 if the SummaryFlag or ThresholdFlag columns are T.

The same value is used for interval 4.

This value can be in seconds, CPU centiseconds, or I/Os (see TypeOfCriterion).