17.00 - QryLogTDWMV - 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
ProcID DECIMAL(5,0) NOT NULL -(5)9 (Prime Key) ID of the Processing Engine from which the query was executed.
CollectTimeStamp TIMESTAMP(6) NOT NULL YYYY-MM-DDBHH:MI:SS.S(6) (Prime Key) Time and date when the DBQLog cache was allocated.
QueryID DECIMAL(18,0) NOT NULL --Z(17)9 (Foreign Key) Systemwide unique value to join DBQL tables.
UserID BYTE(4) NOT NULL X(8) Identifier for the user that issued the query.
UserName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the user who issued the query.
DefaultDatabase VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Default Database name for the user that issued the query.
AcctString VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Unexpanded Account String under which the user issued the query.
SessionID INTEGER NOT NULL --,---,---,--9 SessionID of the query.
LogicalHostID SMALLINT NOT NULL -(5)9 Logical Host ID from which query was executed.
RequestNum INTEGER NOT NULL --,---,---,--9 Host Request number for this query within the session.
InternalRequestNum INTEGER NOT NULL --,---,---,--9 Internal Request number when Stored Procedures are used within the session.
StartTime TIMESTAMP(6) NOT NULL YYYY-MM-DDBHH:MI:SS.S(6) Time and date when the query was submitted to the system.
TDWMAdmissionTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) The time when a request is admitted into the system by workload management (i.e., after ARM processing).
FirstStepTime TIMESTAMP(6) NOT NULL YYYY-MM-DDBHH:MI:SS.S(6) Returns the time the first step for this query is dispatched.
FirstRespTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Time first response was sent to the host.
LastStateChange TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Time of the last state change that occurred.
DeferTime FLOAT ZZ,ZZZ,ZZ9.999 The number of seconds a query was deferred by workload management due to ARM rules.
DeferRuleID INTEGER --,---,---,--9 TDWM Rule ID of one of the ARM rules which caused this request to be deferred.
DelayTime FLOAT ZZ,ZZZ,ZZ9.999 Number of seconds the query was delayed by TDWM.
TDWMRuleID INTEGER --,---,---,--9 RuleId of the TDWM rule causing an object delay.
SessionWDID INTEGER --,---,---,--9 Workload Definition under which the query was parsed.
WDID INTEGER --,---,---,--9 Workload Definition assigned to the query by TDWM.
FinalWDID INTEGER --,---,---,--9 Workload Definition under which the query completed execution.
OpEnvID INTEGER --,---,---,--9 Operational Environment Id in which the query was executed.
SysConID INTEGER --,---,---,--9 System Condition Id in which the query was executed.
LSN INTEGER --,---,---,--9 Logon Sequence Number used by the load utility.
NoClassification CHAR(1) LATIN NOT CASESPECIFIC X(1) T if the query was not classified by TDWM.
WDOverride CHAR(1) LATIN NOT CASESPECIFIC X(1) T if the Workload Definition was overridden by the user.
ResponseTimeMet CHAR(1) LATIN NOT CASESPECIFIC X(1) T if the query met the service level goal of the workload definition.
ExceptionValue INTEGER --,---,---,--9 Type of TDWM exception: e.g. 01-time, 02-CPU, 03-AMP CPU skew, etc.
TDWMEstMaxRows FLOAT ----,---,---,---,--9 Maximum estimated row count used to classify a query into a WD
TDWMEstLastRows FLOAT ----,---,---,---,--9 Last estimated row count made by the optimizer for WD classification.
TDWMEstTotalTime FLOAT ZZZZ9.999999 Total time in seconds estimated by the optimizer used to classify a query into a WD
TDWMEstMemUsage FLOAT ----,---,---,---,--9.999 Estimated memory in MBs used to classify a query into a WD
TDWMAllAmpFlag CHAR(1) LATIN NOT CASESPECIFIC X(1) T if all amp query. Used to classify the query to a WD
TDWMConfLevelUsed CHAR(1) LATIN NOT CASESPECIFIC X(1) Confidence level used to determine what statistics to use to classify the query into a WD.
StatementGroup VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Description of statement(s) issued by the multi-statement or single request.
MinRespHoldTime FLOAT Z,ZZ9.9 Seconds response was held to meet the minimum response time.
TotalFirstRespTime FLOAT ZZ,ZZZ,ZZ9.999 DelayTime + Execution Time + MinRespHoldTime (in seconds)
MaxNumMapAMPs INTEGER --,---,---,--9 Returns the number of AMPs in the largest contiguous map used by the request.
MinNumMapAMPs INTEGER --,---,---,--9 The number of AMPs in the smallest contiguous map used by this request.
SysDefNumMapAMPs INTEGER --,---,---,--9 Number of AMPs in the system-default map.
ProfileName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns Profile name of the user who submitted the query.
WDName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns Workload name assigned to the query.
FinalWDName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the workload definition in which the query completed execution.
SessionWDName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The TDWM workload name used for parsing activity.
OpEnvName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The TDWM operating environment name associated with the OpEnvId.
SysConName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The TDWM System Health Condition name associated with the SysConId.