17.00 - DBQLRulesV - 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

Category: Query

Database: DBC

View Column Data Type Format Comment
UserName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the user associated with the rule.
AccountString VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the specific account for the user with a DBQL rule, or blank if all account strings apply.
ApplName CHAR(30) LATIN NOT CASESPECIFIC NOT NULL X(30) Returns the name of the application.
TypeOfRule VARCHAR(22) UNICODE NOT CASESPECIFIC X(22) Indicates whether logging is enabled or disabled by this rule.
ExplainFlag VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) The following codes are used: T = Explain text is stored in DBC.DBQLExplainTbl F = No Explain text is provided.
ObjFlag VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) are stored in DBC.DBQLObjTbl, F = No object data.
SqlFlag VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) SQL text is stored in DBC.DBQLSqlTbl: T (yes), F (no).
StepFlag VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) The following codes are used: T = Step-level data is stored in DBC.DBQLStepTbl, F = Step-level data is not provided in DBC.DBQLStepTbl.
XMLPlanFlag VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) Indicates whether XML query plan logging is on or off. These are the values: T = On, F = Off.
StatsUsageFlag VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) StatsUsage: T = Statistics usage will be stored, F = No statistics usage.
Verbose VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) Verbose: T = Verbose details provided, F = No verbose details provided
DetailedStats VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) DetailedStats: T = Statistics details provided, F = No Statistics details provided
NoColumns VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) NoColumns: T = Column Details are not logged, F = Column Details are logged
SummaryFlag VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) The following codes are used: T = Summary information is stored in DBC.DBQLSummaryTbl, F = Data is not summarized.
ThresholdFlag VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) T (queries shorter or equal to SummaryVal1 in DBC.DBQLSummaryTbl, detailed data on long queries in DBC.DBQLogTbl), F (detailed data for all queries in DBC.DBQLogTbl unless SummaryFlag is True)
ObjectUsage VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) ObjectUsage: T = Object use counts will be collected, F = No Object use count collection.
ParamFlag VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) Param: T = Parameters and values will be stored, F = No parameter logging.
FeatureUsage VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) FeatureUsage: T = Feature usage will be collected, F = No Feature usage logging.
UtilityInfoFlag VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) Indicates whether utility information will be collected.
TextSizeLimit INTEGER --,---,---,--9 Returns the number of characters of SQL text to be stored in the DBQLogTbl.
SummaryVal1 SMALLINT ---,--9 If Summary or Threshold are T, values <= SummaryVal1 in Elapsed, CPU or IO,
SummaryVal2 SMALLINT ---,--9 Group 2: SummaryVal1 < values <= SummaryVal2 in Elapsed, CPU or IO,
SummaryVal3 SMALLINT ---,--9 Group 3: SummaryVal2 < values <= SummaryVal3 in Elapsed, CPU or IO, & 4: larger than SummaryVal3 in Elapsed, CPU or IO.
LockDelay INTEGER --,---,---,--9 Returns the information if the LockDelay is captured as part of the DBQL query logging rule(renamed to LockDelay).
AlgMode BYTEINT -(3)9 The DBQL CPU/IO Collection Algorithm to use for this rule.
TypeOfCriterion VARCHAR(22) UNICODE NOT CASESPECIFIC X(22) Returns a criterion used for Summary or Threshold.
DetailDiag INTEGER --,---,---,--9 Detail Diagnostic flags