17.00 - QryLogUtilityV - 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) Returns the time that the log entry was generated.
UtilityName VARCHAR(30) UNICODE NOT CASESPECIFIC X(30) Returns the name of the utility.
FastExportNoSpool CHAR(1) LATIN NOT CASESPECIFIC X(1) For utilities implementing FastExport protocol, 'Y' indicates No Spool mode 'N' indicates Spool mode.
ExtendedMLoad CHAR(1) LATIN NOT CASESPECIFIC X(1) 'Y' indicates MLOADX being used 'N' indicates MLOADX not being used.
DSAOperation CHAR(1) LATIN NOT CASESPECIFIC X(1) 'D' indicates DUMP operation 'R' indicates RESTORE operation.
UtilityRequest VARCHAR(2048) UNICODE NOT CASESPECIFIC X(2048) The main utility SQL request for the job. It contains the target database and/or table name(s). The possible statements are: BEGIN LOADING (FastLoad), BEGIN MLOAD (MLOAD/MLOADX), SELECT (FastExport), DUMP/RESTORE (DSA).
JobName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) DSA job name. Not used for other utilities at this time.
JobInstanceID INTEGER --,---,---,--9 DSA job execution ID. Not used for other utilities at this time.
LSN INTEGER --,---,---,--9 Logon Sequence Number used by the utility job.
UserName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Name of the user who ran the utility job.
SessionID INTEGER NOT NULL --,---,---,--9 Session ID of the control SQL session.
LogicalHostID SMALLINT NOT NULL -(5)9 Logical Host ID of the control SQL session.
LogonDateTime TIMESTAMP(6) NOT NULL YYYY-MM-DDBHH:MI:SS.S(6) Date (YYYY-MM-DD) and Time (HH:MM:SS) of the control SQL session logon.
WDID INTEGER --,---,---,--9 Workload definition assigned to the main utility work.
FinalWDID INTEGER --,---,---,--9 Workload definition under which the main utility work completed.
SessionWDID INTEGER --,---,---,--9 Workload definition used for query parsing.
TDWMRuleID INTEGER --,---,---,--9 RuleId of the TDWM rule that caused a delay.
CPUDecayLevel SMALLINT ---,--9 Contains most severe decay level reached for CPU usage.
IODecayLevel SMALLINT ---,--9 Contains most severe decay level reached for I/O usage.
UserID BYTE(4) NOT NULL X(8) Identifier of the user who submitted the utility job.
ZoneID BYTE(4) NOT NULL X(8) Zone ID of the user who submitted the utility job.
AcctString VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Unexpanded Account String of the user who submitted the utility job.
ExpandAcctString VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) If account expansion was invoked, account string in expanded format.
AcctStringTime FLOAT 99:99:99 Time (HH:MM:SS) if account string contains $T.
AcctStringHour SMALLINT -(5)9 Hour (HH) if account string contains $H.
AcctStringDate DATE YY/MM/DD Date (YY/MM/DD) if account string contains $D.
LogonSource CHAR(128) LATIN NOT CASESPECIFIC X(128) Identification of the place from where the user accessed the system.
AppID CHAR(30) UNICODE NOT CASESPECIFIC X(30) Application ID of the utility job.
ClientID CHAR(30) UNICODE NOT CASESPECIFIC X(30) Client ID of the utility job.
ClientAddr CHAR(45) LATIN NOT CASESPECIFIC X(45) Client address of the utility job.
QueryBand VARCHAR(12304) UNICODE NOT CASESPECIFIC X(12304) Query band used in the utility job.
ProfileID BYTE(4) X(8) Profile ID used for the utility job.
ProxyUser VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Proxy user used for the utility job.
ProxyRole VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Proxy role used for the utility job.
OpEnvID INTEGER --,---,---,--9 Operational Environment ID in which the utility job was executed.
SysConID INTEGER --,---,---,--9 System Condition ID in which the utility job was executed.
NoClassification CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
WDOverride CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
ResponseTimeMet CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
DelayTime FLOAT ----,---,---,---,--9.999 Number of seconds the utility job was delayed by TDWM.
JobStartTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Job start time.
JobEndTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Job end time.
RowsInserted FLOAT ----,---,---,---,--9 Number of rows inserted by the utility job.
RowsUpdated FLOAT ----,---,---,---,--9 Number of rows updated by the utility job.
RowsDeleted FLOAT ----,---,---,---,--9 Number of rows deleted by the utility job.
RowsExported FLOAT ----,---,---,---,--9 Number of rows exported by the utility job.
NumSesOrBuildProc SMALLINT -(5)9 Number of sessions used. For DSA, number of build processes used.
MaxDataWaitTime FLOAT ----,---,---,---,--9 The highest wait time in seconds from external source for input data or output requests.
MaxDataWaitTimeID INTEGER --,---,---,--9 ID associated with the highest wait time.
Phase0StartTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Returns phase 0 start date and time of the utility job.
Phase0EndTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Returns phase 0 end date and time of the utility job.
Phase0TotalCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Phase 0 total CPU Time in seconds.
Phase0TotalCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Phase 0 total normalized CPU Time in seconds.
Phase0ParserCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Phase 0 Parser and Dispatcher CPU time in seconds.
Phase0ParserCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Phase 0 normalized Parser and Dispatcher CPU time in seconds.
Phase0TotalIO FLOAT ----,---,---,---,--9 Phase 0 logical I/O count.
Phase0IOKB FLOAT ----,---,---,---,--9.999 Phase 0 logical I/O in KB.
Phase0PhysIO FLOAT ----,---,---,---,--9.999 Returns the number of physical I/Os in phase 0 of the utility job.
Phase0PhysIOKB FLOAT ----,---,---,---,--9.999 Returns total physical I/O usage in kilobytes in phase 0 of the utility job.
Phase1StartTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Returns phase 1 start date and time of the utility job.
Phase1EndTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Returns phase 1 end date and time of the utility job.
Phase1TotalCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Phase 1 total CPU Time in seconds.
Phase1TotalCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Phase 1 total normalized CPU Time in seconds.
Phase1MaxCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Phase 1 highest AMP CPU time in seconds.
Phase1MaxCPUAmpNumber INTEGER --,---,---,--9 Phase 1 - ID of AMP with highest CPU time.
Phase1MaxCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Phase 1 highest normalized AMP CPU time in seconds.
Phase1MaxCPUAmpNumberNorm INTEGER --,---,---,--9 Phase 1 - ID of AMP with highest normalized CPU time.
Phase1ParserCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Phase 1 Parser and Dispatcher CPU time in seconds.
Phase1ParserCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Phase 1 normalized Parser and Dispatcher CPU time in seconds.
Phase1RSGCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Phase 1 RSG CPU time in seconds.
Phase1RSGCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Phase 1 normalized RSG CPU time in seconds.
Phase1TotalIO FLOAT ----,---,---,---,--9 Phase 1 logical I/O count.
Phase1MaxIO FLOAT ----,---,---,---,--9 Phase 1 highest logical I/O count.
Phase1MaxIOAmpNumber INTEGER --,---,---,--9 Phase 1 - ID of AMP with highest logical I/O count.
Phase1IOKB FLOAT ----,---,---,---,--9.999 Phase 1 logical I/O in KB.
Phase1PhysIO FLOAT ----,---,---,---,--9.999 Returns the number of physical I/Os in phase 1 of the utility job.
Phase1PhysIOKB FLOAT ----,---,---,---,--9.999 Returns total physical I/O usage in kilobytes in phase 1 of the utility job.
Phase1MaxAWTUsage BYTEINT -(3)9 Phase 1 highest AWT usage.
Phase1MaxAMPMemoryUsage FLOAT ----,---,---,---,--9 Phase 1 highest AMP memory usage in MBs.
Phase1MaxRSGMemoryUsage FLOAT ----,---,---,---,--9 Phase 1 highest RSG memory usage in MBs.
Phase1RowCount FLOAT ----,---,---,---,--9 Phase 1 row count.
Phase1BlockCount FLOAT ----,---,---,---,--9 Phase 1 block count.
Phase1ByteCount FLOAT ----,---,---,---,--9 Phase 1 byte count.
Phase2StartTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Returns phase 2 start date and time of the utility job.
Phase2EndTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Returns phase 2 end date and time of the utility job.
Phase2TotalCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Phase 2 total CPU Time in seconds .
Phase2TotalCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Phase 2 total normalized CPU Time in seconds.
Phase2MaxCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Phase 2 highest AMP CPU time in seconds.
Phase2MaxCPUAmpNumber INTEGER ZZ,ZZZ,ZZ9.999 Phase 2 - ID of AMP with highest CPU time.
Phase2MaxCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Phase 2 highest normalized AMP CPU time in seconds.
Phase2MaxCPUAmpNumberNorm INTEGER --,---,---,--9 Phase 2 - ID of AMP with highest normalized CPU time.
Phase2ParserCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Phase 2 Parser and Dispatcher CPU time in seconds.
Phase2ParserCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Phase 2 normalized Parser and Dispatcher CPU time in seconds.
Phase2RSGCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Phase 2 RSG CPU time in seconds.
Phase2RSGCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Phase 2 normalized RSG CPU time in seconds.
Phase2TotalIO FLOAT ----,---,---,---,--9 Phase 2 logical I/O count.
Phase2MaxIO FLOAT ----,---,---,---,--9 Phase 2 highest logical I/O count.
Phase2MaxIOAmpNumber INTEGER --,---,---,--9 Phase 2 - ID of AMP with highest logical I/O count.
Phase2IOKB FLOAT ----,---,---,---,--9.999 Phase 2 logical I/O in KB.
Phase2PhysIO FLOAT ----,---,---,---,--9.999 Returns the number of physical I/Os in phase 2 of the utility job.
Phase2PhysIOKB FLOAT ----,---,---,---,--9.999 Returns total physical I/O usage in kilobytes in phase 2 of the utility job.
Phase2MaxAWTUsage BYTEINT -(3)9 Phase 2 highest AWT usage.
Phase2MaxAMPMemoryUsage FLOAT ----,---,---,---,--9 Phase 2 highest AMP memory usage in MBs.
Phase2MaxRSGMemoryUsage FLOAT ----,---,---,---,--9 Phase 2 highest RSG memory usage in MBs.
Phase2RowCount FLOAT ----,---,---,---,--9 Phase 2 row count.
Phase2BlockCount FLOAT ----,---,---,---,--9 Phase 2 block count.
Phase2ByteCount FLOAT ----,---,---,---,--9 Phase 2 byte count.
Phase3StartTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Returns phase 3 start date and time of the utility job.
Phase3EndTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Returns phase 3 end date and time of the utility job.
Phase3TotalCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Phase 3 total CPU Time in seconds.
Phase3TotalCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Phase 3 total normalized CPU Time in seconds.
Phase3ParserCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Phase 3 Parser and Dispatcher CPU time in seconds.
Phase3ParserCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Phase 3 normalized Parser and Dispatcher CPU time in seconds.
Phase3RSGCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Phase 3 RSG CPU time in seconds.
Phase3RSGCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Phase 3 normalized RSG CPU time in seconds.
Phase3TotalIO FLOAT ----,---,---,---,--9 Phase 3 logical I/O count.
Phase3IOKB FLOAT ----,---,---,---,--9.999 Phase 3 logical I/O in KB.
Phase3PhysIO FLOAT ----,---,---,---,--9.999 Returns the number of physical I/Os in phase 3 of the utility job.
Phase3PhysIOKB FLOAT ----,---,---,---,--9.999 Returns total physical I/O usage in kilobytes in phase 3 of the utility job.
Phase3MaxAWTUsage BYTEINT -(3)9 Phase 3 highest AWT usage.
Phase3MaxAMPMemoryUsage FLOAT ----,---,---,---,--9 Phase 3 highest AMP memory usage in MBs.
Phase3MaxRSGMemoryUsage FLOAT ----,---,---,---,--9 Phase 3 highest RSG memory usage in MBs.
Phase4StartTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Returns phase 4 start date and time of the utility job.
Phase4EndTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Returns phase 4 end date and time of the utility job.
Phase4TotalCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Phase 4 total CPU Time in seconds.
Phase4TotalCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Phase 4 total normalized CPU Time in seconds.
Phase4ParserCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Phase 4 Parser and Dispatcher CPU time in seconds.
Phase4ParserCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Phase 4 normalized Parser and Dispatcher CPU time in seconds.
Phase4TotalIO FLOAT ----,---,---,---,--9 Phase 4 logical I/O count.
Phase4IOKB FLOAT ----,---,---,---,--9.999 Phase 4 logical I/O in KB.
Phase4PhysIO FLOAT ----,---,---,---,--9.999 Returns the number of physical I/Os in phase 4 of the utility job.
Phase4PhysIOKB FLOAT ----,---,---,---,--9.999 Returns total physical I/O usage in kilobytes in phase 4 of the utility job.
Phase0UsedIota FLOAT ----,---,---,---,--9.999 Returns used IOTAs in phase 0 of the utility job.
Phase1UsedIota FLOAT ----,---,---,---,--9.999 Returns used IOTAs in phase 1 of the utility job.
Phase2UsedIota FLOAT ----,---,---,---,--9.999 Returns used IOTAs in phase 2 of the utility job.
Phase3UsedIota FLOAT ----,---,---,---,--9.999 Returns used IOTAs in phase 3 of the utility job.
Phase4UsedIota FLOAT ----,---,---,---,--9.999 Returns used IOTAs in phase 4 of the utility job.
ProfileName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the profile, if any, under which the user submitted the utility job.
WDName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the workload definition (WD) name assigned to the utility job.
FinalWDName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the workload definition name in which the utility job completed execution.
SessionWDName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns workload definition name associated with the session.
OpEnvName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the operating environment currently activated by the Teradata dynamic workload management software.
SysConName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the system condition currently activated by the Teradata dynamic workload management software.
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.
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).