17.00 - QryLogV - 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 Returns the process ID of the dispatcher.
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 Returns a system-wide unique ID to identify the query.
UserID BYTE(4) NOT NULL X(8) Returns the ID of the user.
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) Returns the name of the current default database for the user.
AcctString VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Unexpanded Account String under which the user issued the query.
ExpandAcctString VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the expanded logon string of the user.
SessionID INTEGER NOT NULL --,---,---,--9 SessionID of the query.
LogicalHostID SMALLINT NOT NULL -(5)9 Returns a unique identifier of the logon source for the logged query. A value of zero indicates an internal session.
RequestNum INTEGER NOT NULL --,---,---,--9 Client request number for all queries. For statements within stored procedure CALL statements, the request number is the same as the CALL.
InternalRequestNum INTEGER NOT NULL --,---,---,--9 Returns the internal request number used by the Teradata Database.
TxnUniq BYTE(4) X(8) Transaction Uniq portion used with ProcId.
LockLevel VARCHAR(10) LATIN NOT CASESPECIFIC X(10) Highest level lock associated with this request.
LogonDateTime TIMESTAMP(6) NOT NULL YYYY-MM-DDBHH:MI:SS.S(6) Returns the date and time that the session was logged on.
AcctStringTime FLOAT 99:99:99 Returns the result from the &T code when the user has specified Account String Expansion (ASE).
AcctStringHour SMALLINT -(5)9 Returns the result from the &H code when the user has specified Account String Expansion (ASE).
AcctStringDate DATE YY/MM/DD Returns the result from the &D code when the user has specified Account String Expansion (ASE).
LogonSource CHAR(128) LATIN NOT CASESPECIFIC X(128) Channel-Attached Systems Using the CLIv2 API Returns the origin of the CLIv2 mainframe session being reported, such as the user ID or session number of the client system.
AppID CHAR(30) UNICODE NOT CASESPECIFIC X(30) Returns the application ID.
ClientID CHAR(30) UNICODE NOT CASESPECIFIC X(30) Returns the client ID.
ClientAddr CHAR(45) LATIN NOT CASESPECIFIC X(45) The client address of the submitted query.
QueryBand VARCHAR(12304) UNICODE NOT CASESPECIFIC X(12304) Returns the band under which the query is submitted.
ProfileID BYTE(4) X(8) Returns the unique number assigned to the cost profile instance in the system.
StartTime TIMESTAMP(6) NOT NULL YYYY-MM-DDBHH:MI:SS.S(6) Returns the time the query is submitted.
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.
ElapsedTime HS -h(4):mm:ss.s(6) Returns the difference between first response time and start time.
NumSteps SMALLINT NOT NULL ---,--9 Returns the total number of (level 1) steps for this query.
NumJoinSteps SMALLINT ---,--9 Number of Join Steps in the request.
NumSumSteps SMALLINT ---,--9 Number of Sum steps in the request.
NumStepswPar SMALLINT ---,--9 Returns the number of (level 1) steps with parallel steps.
MaxStepsInPar SMALLINT ---,--9 Returns the maximum number of (level 2) steps done in parallel for this query.
NumResultRows FLOAT ----,---,---,---,--9 Returns the total number of rows returned for the query.
NumResultOneMBRows FLOAT ----,---,---,---,--9 The number of 1MB rows (1MB > size > 64KB) in the set of rows returned for the query.
MaxOneMBRowSize INTEGER --,---,---,--9 The actual size in bytes of the largest 1MB row in the set of rows returned for the query.
TotalIOCount FLOAT ----,---,---,---,--9 Returns the number of IOs from AMPs that were generated by the query.
AMPCPUTime FLOAT ZZ,ZZZ,ZZ9.999 The total AMP CPU time in seconds used by this query.
ParserCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Returns the total parser and dispatcher CPU time in seconds used for the query.
UtilityByteCount BIGINT --,---,---,---,---,---,--9 The number of bytes transferred by client as part of FastLoad or MultiLoad job.
UtilityRowCount FLOAT ----,---,---,---,--9 Returns the number of rows loaded by FastLoad or MultiLoad.
ErrorCode INTEGER --,---,---,--9 Returns an error code.
ErrorText VARCHAR(1024) UNICODE NOT CASESPECIFIC X(1024) Returns the text from the error if ErrorCode is not 0.
WarningOnly CHAR(1) LATIN NOT CASESPECIFIC X(1) Returns warning code T for true if the error was reported while running TDWM in the warning mode, or it is not logged at all. A null is found in the field if WarningOnly is not true.
AbortFlag CHAR(1) LATIN NOT CASESPECIFIC X(1) Returns an indicator if this query was aborted.
CacheFlag CHAR(1) LATIN NOT CASESPECIFIC X(1) This field is blank if the query is not found in step cache.
StatementType CHAR(20) LATIN NOT CASESPECIFIC X(20) Statement type issued by the query. Final statement type in a multistatement request.
StatementGroup VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the grouping for the query, whether it is a DDL, DML, or SELECT statement.
QueryText VARCHAR(10000) UNICODE NOT CASESPECIFIC X(10000) Returns the query text. The default size is 200 characters.
NumOfActiveAMPs INTEGER --,---,---,--9 Returns the number of AMPS that were active for this query.
MaxAMPCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Returns the CPU time in seconds of the highest CPU utilized AMP in the query.
MaxCPUAmpNumber INTEGER --,---,---,--9 Returns the number of the AMP with the highest CPU activity.
MinAmpCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Returns the CPU time in seconds of the lowest CPU utilized AMP in the step.
MaxAmpIO FLOAT ----,---,---,---,--9 (renamed from HotAmpIO) Returns the I/O count of the highest I/O utilized AMP in the step.
MaxIOAmpNumber INTEGER --,---,---,--9 Returns the number of the AMP with the highest IO usage for this step.
MinAmpIO FLOAT ----,---,---,---,--9 (renamed from LowAmpIO) Returns the I/O count of the lowest I/O utilized AMP in the query.
SpoolUsage BIGINT --,---,---,---,---,---,--9 Peak Spool usage (bytes) of any step in the query (DataCollectAlg=3). Otherwise, number of bytes used for spool in the query.
LSN INTEGER --,---,---,--9 Is used in the case of a load utility.
EstResultRows FLOAT ----,---,---,---,--9 Estimated number of rows returned by this query.
EstProcTime FLOAT ZZ,ZZZ,ZZ9.999 EstProcTime returns the estimated processing time in seconds (with .001 resolution) from the Optimizer.
EstMaxStepTime FLOAT ZZ,ZZZ,ZZ9.999 The estimated maximum step time in seconds from the optimizer.
EstMaxRowCount FLOAT ----,---,---,---,--9 Maximum of estimated row count for the steps in this query.
TDWMEstMemUsage FLOAT ZZ,ZZZ,ZZ9.999 Maximum estimated memory in MBs for largest step.
AMPCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Normalized total AMP CPU time in seconds used by this query.
ParserCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Returns the normalized parser CPU time in seconds for co-existence systems.
MaxAMPCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Returns the normalized maximum CPU Time in seconds for AMP.
MaxCPUAmpNumberNorm INTEGER --,---,---,--9 Returns the number of the AMP with the highest CPU activity.
MinAmpCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Returns the normalized minimum CPU Time in seconds for AMP.
ParserExpReq FLOAT ZZ,ZZZ,ZZ9.999 Hundredths of seconds of elapsed time (35 is .35 seconds) in instrumented parser exp requests.
ProxyUser VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the proxy user.
ProxyRole VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The proxy role utilized for the query.
SessionTemporalQualifier VARCHAR(1024) LATIN NOT CASESPECIFIC X(1024) DBC.QryLogV.SessionTemporalQualifier records the session temporal qualifier for the session apart from the SQL Stored
CalendarName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) DBC.QryLogV.CalendarName records the Calendar Name set for the session
CPUDecayLevel SMALLINT ---,--9 Contains most severe decay level reached for CPU usage on any one node.
IODecayLevel SMALLINT ---,--9 Contains most severe decay level reached for IO usage on any one node.
TacticalCPUException INTEGER --,---,---,--9 The total number of nodes that had CPU exception.
TacticalIOException INTEGER --,---,---,--9 The total number of nodes that had IO exception.
SeqRespTime FLOAT ZZ,ZZZ,ZZ9.999 Contains sum of the response time of all steps as if they had been executed sequentially in units of seconds.
ReqIOKB FLOAT ZZ,ZZZ,ZZ9.999 Total logical IO usage in kilobytes for the request.
ReqPhysIO FLOAT ZZ,ZZZ,ZZ9.999 Number of physical IOs for the request.
ReqPhysIOKB FLOAT ZZ,ZZZ,ZZ9.999 Total physical IO usage in kilobytes for the request.
DataCollectAlg BYTEINT -(3)9 The data collection algorithm used by DBQL.
CallNestingLevel BYTEINT -(3)9 The level of nesting when the request is running in stored procedure.
NumRequestCtx BYTEINT -(3)9 Number of request contexts associated with the session.
KeepFlag CHAR(1) LATIN NOT CASESPECIFIC X(1) This is a flag with value (Y) or (N) indicating that the response parcel should be kept until the client responds that it no longer needs it.
QueryRedriven CHAR(1) LATIN NOT CASESPECIFIC X(1) This is a flag with value (Y) or (N) to indicate if the query was re-driven.
ReDriveKind CHAR(10) LATIN NOT CASESPECIFIC X(10) Contains the type of reset protection with which the query was re-driven. (MN)-Memory Non-fallback responses, (DF)-Dictionary table Fallback responses, (DN)-Dictionary Table Non-fallback responses.
LastRespTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) End of the request, end of the host/client response phase where applicable (DataCollectAlg=3).
DisCPUTime FLOAT ----,---,---,---,--9.999 The CPU time used in the dispatcher by this query (seconds).
Statements INTEGER --,---,---,--9 Number of statements in the request.
DisCPUTimeNorm FLOAT ----,---,---,---,--9.999 The Normalized CPU time used in the dispatcher by this query (seconds).
TxnMode CHAR(10) LATIN NOT CASESPECIFIC X(10) Transaction mode of this query (ANSI, BTET).
RequestMode CHAR(5) LATIN NOT CASESPECIFIC X(5) Request mode of this query: Prep - only prepare query; PrepS - only prepare query, parameterized SQL; Exec - execute the query; Both - Prepare and Execute query.
DBQLStatus INTEGER --,---,---,--9 Internal DBQL logging status. Zero indicates no status conditions (DataCollectAlg=3).
NumFragments INTEGER --,---,---,--9 The number of fragments in a IPE plan execution of request.
VHLogicalIO FLOAT ----,---,---,---,--9.999 Total number of Very Hot logical I/Os for the whole request.
VHPhysIO FLOAT ----,---,---,---,--9.999 Total number of Very Hot Physical I/Os for the whole request.
VHLogicalIOKB FLOAT ----,---,---,---,--9.999 Total Very Hot logical I/Os in kilobytes for the whole request.
VHPhysIOKB FLOAT ----,---,---,---,--9.999 Total Very Hot Physical I/Os in kilobytes for the whole request.
LockDelay FLOAT ----,---,---,---,--9.999 Maximum wait time to get a lock on object in centi-seconds.
CheckpointNum FLOAT ----,---,---,---,--9 Checkpoint interval number for MLOADX.
UnityTime FLOAT ----,---,---,---,--9.999 Time in seconds the stored procedure request was being processed by Unity.
UtilityInfoAvailable CHAR(1) LATIN NOT CASESPECIFIC X(1) Indication if a request also has utility information available in the DBQLUtilityTbl table.
UnitySQL CHAR(1) LATIN NOT CASESPECIFIC X(1) Y - indicates Unity requested the SQL be modified. This will be set when Unity asks for Unity transaction table to be updated.
ThrottleBypassed CHAR(1) LATIN NOT CASESPECIFIC X(1) Request was only allowed to run due to the throttlebypass feature of TDWM.
FlexThrottle CHAR(1) LATIN NOT CASESPECIFIC X(1) Flag 'T' indicates this query was released from the TDWM delay queue due to the Flex Throttle feature.
IterationCount INTEGER --,---,---,--9 Iteration count for data parcel associated with a request.
TTGranularity VARCHAR(30) UNICODE NOT CASESPECIFIC NOT NULL X(30) Records the Transaction Time Granularity Name set for the session
MaxStepMemory FLOAT ----,---,---,---,--9.999 The maximum memory in MBs used by any one step in the request.
TotalServerByteCount BIGINT --,---,---,---,---,---,--9 Total bytes sent and received from the foreign server.
PersistentSpool BIGINT --,---,---,---,---,---,--9 Persistent part of SpoolUsage.
RemoteQuery CHAR(1) LATIN NOT CASESPECIFIC X(1) Flag 'T' indicates a remote query has been submitted.
ProxyUserID BYTE(4) X(8) The ID of the Proxy User.
DelayTime FLOAT ZZ,ZZZ,ZZ9.999 Returns the number of seconds the query was delayed by Workload Management.
TDWMRuleID INTEGER --,---,---,--9 Returns the TDWM RuleId causing the DelayTime.
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)
ParamQuery CHAR(1) LATIN NOT CASESPECIFIC X(1) Flag 'T' indicates the query is parameterized.
ProfileName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the profile, if any, under which the user submitted the query.
WDName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the workload definition (WD) name assigned to the utility job.
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.
UsedIota FLOAT ZZ,ZZZ,ZZ9.999 Return IO Tokens used by the requests.
ImpactSpool BIGINT -(19)9 System level spool impact by the request
AutoDBAData CHAR(1) LATIN NOT CASESPECIFIC X(1) Values indicate if the request contains AutoDBA Data.
UAFName CHAR(10) LATIN NOT CASESPECIFIC X(10) Name of an Analytic Function being executed by EXECUTE FUNCTION. The default is NULL.
UnityQueryType BYTEINT -(3)9 Indicates if it is a replayed SQL or CDA.
DefaultDBCacheUsed CHAR(1) LATIN NOT CASESPECIFIC X(1) Value of 'T' indicating that default DB part of the step cache used, 'F' otherwise. NULL if request not cached.
ReqAWTTime FLOAT ----,---,---,---,--9.999 Returns AWT elapsed time in seconds for the request.
MaxReqAwtTime FLOAT ----,---,---,---,--9.999 Returns Max AWT elapsed time in seconds for the request.
MaxReqAWTTimeAmpNum INTEGER --,---,---,--9 Returns AMP number that had max AWTTime for the request.
MinReqAWTTime FLOAT ----,---,---,---,--9.999 Returns Min AWT elapsed time in seconds for the request.
UDFVMData FLOAT ----,---,---,---,--9.999 UDF Virtual memory data size for the request.
UDFVMPeak FLOAT ----,---,---,---,--9.999 UDF Virtual memory peak for the request.
TotalUDFMemUsage FLOAT ----,---,---,---,--9.999 Total memory in bytes used by UDF for the request.
MaxReqUDFMemUsage FLOAT ----,---,---,---,--9.999 Max memory in bytes used by UDF for the request.
MaxReqUDFMemUsageAmpNum INTEGER --,---,---,--9 AMP number that had max memory used by UDF for this request.
PGRCTimeToGetPlan FLOAT ----,---,---,---,--9.999 Time taken for communication between Cache Management Threads and session Thread to get plan from target PE when Partitioned Global Request Cache feature is ON.
PGRCTgtPENum SMALLINT ---,--9 Returns the target PE number which holds the PSTEPS for this request when PGRC feature is ON.
NosRecordsReturned BIGINT --,---,---,---,---,---,--9 Number of records returned by a Native Object Store request.
NosRecordsSkipped BIGINT --,---,---,---,---,---,--9 Number of records skipped by a Native Object Store request.
NosPhysReadIO BIGINT --,---,---,---,---,---,--9 Total physical read IOs for Native Object Store files.
NosPhysReadIOKB FLOAT ----,---,---,---,--9.999 Total KB of physical read IOs for Native Object Store files.
NosRecordsReturnedKB FLOAT ----,---,---,---,--9.999 Total KB of records returned for Native Object Store files.
NosTotalIOWaitTime FLOAT ----,---,---,---,--9.999 Total of the Native Object Store IO wait time in seconds for the request.
NosMaxIOWaitTime FLOAT ----,---,---,---,--9.999 Max Native Object Store IO wait time for any individual IO. Units in seconds.
NosCPUTime FLOAT ----,---,---,---,--9.999 CPU time in seconds for reading Native Object Store files for the request.
NosTables INTEGER --,---,---,--9 Total number of Native Object Store tables accessed in the request. Note that access via READ_NOS does not increment this column, although it does increment the other NOS columns.
NosFiles INTEGER --,---,---,--9 Numbers of Native Object Store file reads were attempted on by this request.
NosFilesSkipped INTEGER --,---,---,--9 Number of Native Object Store files that were skipped.
StepCacheHash INTEGER --Z(17)9 Step cache hash value of this request if cached, NULL otherwise.
ResponseTimeMet CHAR(1) LATIN NOT CASESPECIFIC X(1) 'T' if the query met the service level goal of the workload definition.
TDWMMSRCount INTEGER --,---,---,--9 The number of statements excluding BT, ET, Commit, Macros, Materialized Tmp Tables and Null statements in the Request.
DeferTime FLOAT ----,---,---,---,--9.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.
StmtDMLRowCount JSON X(128) Returns the row count for DML(Insert or Update or Delete) statements.
UnityQueryForeignInfo VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) UnityForeignQueryID and UnityForeignSystemID