16.10 - Utility Job Log Table: DBQLUtilityTbl - Teradata Database

Teradata Database Administration
Product
Teradata Database
Release Number
16.10
Published
April 2018
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
qjg1509413559832.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval
dita:id
ujp1472240543947

This table is populated if you use the WITH UTILITYINFO option for BEGIN/REPLACE QUERY LOGGING. Each row stores information for one completed load/export utility or Data Stream Architecture job.

The following table describes the different column phases listed below.
Utility Protocols Phase Zero Name Phase One Name Phase Two Name Phase Three Name Phase Four Name
FastLoad

MLOAD

MLOADX

 Setup Acquisition Application Cleanup N/A
FastExport Setup Select Export Cleanup N/A
DSA N/A Dictionary Data Build Postscript

Phase1 and Phase2 columns are used for the required phases. Phase0, Phase3, and Phase4 columns are used for the optional phases.

DBC.DBQLUtilityTbl Field Description
AcctString Unexpanded account name under which the utility job is submitted.
AcctStringDate Value of the expanded &D ASE code in the account string. If none exists, the value is denoted with a “?” and is null.

Even if ASE truncates the expanded account string, DBQL will report the full value. For example, if &D is expanded into position 26 or higher in the account definition and truncation occurs, DBQL will still report the entire value of the date in the AcctStringDate column.
AcctStringHour Value of the expanded &H ASE code in the account string. If none exists, the value is denoted with a “?” and is null.
AcctStringTime Value of the expanded &T ASE code in the account string. If none exists, the value is denoted with a “?” and is null.
AppID Application (executable) or utility name; for example, FASTLOAD from LogonSource for network clients.
ClientID Network client user name under which this session is logged (for example, ADMIN).
ClientAddr Client IP address of the submitted utility job as obtained from Logonsource from a network client.
CollectTimeStamp A date and time when information collection for the job is completed.
CPUDecayLevel Decay level reached for CPU usage per AMP, for requests using the default Timeshare workload management method. Values are 0, 1, or 2. A value of 0 indicates that the request is running at the default priority. A value of 1 indicates that the priority level is reduced and the resource allotment is halved. A value of 2 indicates that the priority level is reduced again, the resource allotment is halved again, and it will not be reduced more.
DelayTime Seconds a query was delayed by the Teradata dynamic workload management software.
DSAOperation
  • D indicates DUMP operation.
  • R indicates RESTORE operation.
ExpandAcctString Expanded account name under which the utility job is submitted if account expansion is invoked.
The &I, which gives the host, session, and request number for the query is different for a stored procedure call. For stored procedure calls, the request number is the client request number which is the request of the CALL statement.
ExtendedMLoad
  • Y indicates MLOADX.
  • N indicates MLOADX is not being used.
FastExportNoSpool For utilities implementing FastExport protocol:
  • Y indicates No Spool mode.
  • N indicates Spool mode.
FinalWDID Workload definition under which the main utility work completed execution.
IODecayLevel Decay level reached for I/O usage per AMP, for requests using the default Timeshare workload management method. Values are 0, 1, or 2. A value of 0 indicates that the request is running at the default priority. A value of 1 indicates that the priority level is reduced and the resource allotment is halved. A value of 2 indicates that the priority level is reduced again, the resource allotment is halved again, and it will not be reduced more.
JobEndTime Job end time.
JobInstanceID DSA job execution ID. Not used for other utilities at this time.
JobName DSA job name. Not used for other utilities at this time.
JobStartTime Job start time.
LogicalHostID Logical host ID of the control SQL session.
LogonDateTime Date (for example, YYYY-MM-DD) and time (for example, HH:MM:SS) of the control SQL session logon.
LogonSource Logon source string text.
LSN Logon Sequence Number.
MaxDataWaitTime Maximum wait time from external source for input data or output requests.
MaxDataWaitTimeID
  • For FastLoad, MultiLoad, and FastExport: The ID of the AMP owning the utility session with the highest data wait time.
  • For MLOADX: The session number of the session with the highest data wait time.
  • For DSA: The ID of the stream with the highest data wait time.
NumSesOrBuildProc For load/export utilities, it is the number of utility sessions. For DSA, it is the number of build processes.
OpEnvID Internal identifier of the Operating Environment / Planned Environment currently enforced by the Teradata dynamic workload management software.
Phase0EndTime Phase 0: End time.
Phase0IOKB Phase 0: Logical I/Os in KB.
Phase0ParserCPUTime Phase 0: Parser and Dispatcher CPU time.
Phase0ParserCPUTimeNorm Phase 0: Normalized Parser and Dispatcher CPU time.
Phase0PhysIO Phase 1: Physical I/O count.
Phase0PhysIOKB Phase 0: Physical I/O in KB.
Phase0StartTime Phase 0: Start time.
Phase0TotalCPUTime Phase 0: Total CPU time.
Phase0TotalCPUTimeNorm Phase 0: Total normalized CPU time.
Phase0TotalIO Phase 0: Total logical I/Os.
Phase1BlockCount Phase 1: Block (message) count.
Phase1ByteCount Phase 1: Byte count.
Phase1EndTime Phase 1: End time.
Phase1IOKB Phase 1: Total logical I/O usage in KB.
Phase1MaxAMPMemoryUsage Phase 1: Maximum AMP memory usage.
Phase1MaxAWTUsage Phase 1: Maximum number of AMP worker tasks (AWTs) used. Not available for DSA and FastExport using spool.
Phase1MaxCPUAmpNumber Phase 1: ID of the AMP with the highest CPU usage.
Phase1MaxCPUAmpNumberNorm Phase 1: ID of the AMP with the highest normalized CPU usage.
Phase1MaxCPUTime Phase 1: CPU usage of the most-used AMP.
Phase1MaxCPUTimeNorm Phase 1: Normalized CPU usage of the most-used AMP.
Phase1MaxIO Phase 1: Logical I/Os of the most-used AMP.
Phase1MaxIOAmpNumber Phase 1: ID of the AMP with the most logical I/Os.
Phase1MaxRSGMemoryUsage Phase 1: For DSA, the maximum RSG memory usage.
Phase1ParserCPUTime Phase 1: Parser CPU usage.
Phase1ParserCPUTimeNorm Phase 1: Normalized parser CPU usage.
Phase1PhysIO Phase 1: Total physical I/O usage.
Phase1PhysIOKB Phase 1: Total physical I/O usage in KB.
Phase1RowCount Phase 1: Row count.
Phase1RSGCPUTime Phase 1: RSG CPU usage for Data Stream Architecture (DSA).
Phase1RSGCPUTimeNorm Phase 1: Normalized RSG CPU usage for Data Stream Architecture (DSA).
Phase1StartTime Phase 1: Start time.
Phase1TotalCPUTime Phase 1: Total CPU time.
Phase1TotalCPUTimeNorm Phase 1: Total normalized CPU usage.
Phase1TotalIO Phase 1: Total logical I/Os.
Phase2BlockCount Phase 2: For DSA, the number of blocks processed.
Phase2ByteCount Phase 2: For DSA, the total count of bytes processed.
Phase2EndTime Phase 2: End time.
Phase2IOKB Phase 2: Total logical I/O usage in KB.
Phase2MaxAMPMemoryUsage Phase 2: Maximum AMP memory usage.
Phase2MaxAWTUsage Phase 2: Maximum number of AWTs used.
Phase2MaxCPUAmpNumber Phase 2: ID of the AMP with the highest CPU usage.
Phase2MaxCPUAmpNumberNorm Phase 2: ID of the AMP with the highest normalized CPU usage.
Phase2MaxCPUTime Phase 2: CPU usage of the most-used AMP.
Phase2MaxCPUTimeNorm Phase 2: Normalized CPU usage of the most-used AMP.
Phase2MaxIO Phase 2: Logical I/Os of the most-used AMP.
Phase2MaxIOAmpNumber Phase 2: ID of the AMP with the most logical I/Os.
Phase2MaxRSGMemoryUsage Phase 2: For DSA, Maximum RSG memory usage.
Phase2ParserCPUTime Phase 2: Parser CPU usage.
Phase2ParserCPUTimeNorm Phase 2: Normalized parser CPU usage.
Phase2ParserCPUTimeNorm Phase 2: Normalized Parser and Dispatcher CPU time.
Phase2PhysIO Phase 2: Total physical I/Os.
Phase2PhysIOKB Phase 2: Total physical I/O usage in KB.
Phase2RSGCPUTime Phase 2: For DSA, the RSG CPU usage.
Phase2RSGCPUTimeNorm Phase 2: For DSA, the normalized RSG CPU usage.
Phase2StartTime Phase 2: Start time.
Phase2TotalCPUTime Phase 2: Total CPU usage.
Phase2TotalCPUTimeNorm Phase 2: Total normalized CPU usage.
Phase2TotalIO Phase 2: Total logical I/Os.
Phase3EndTime Phase 3: End time.
Phase3IOKB Phase 3: Total logical I/O usage in KB.
Phase3MaxAMPMemoryUsage Phase 3: Maximum AMP memory usage.
Phase3MaxAWTUsage Phase 3: Maximum number of AWTs used.
Phase3MaxRSGMemoryUsage Phase 3: For DSA, the maximum RSG memory usage.
Phase3ParserCPUTime Phase 3: Parser CPU usage.
Phase3ParserCPUTimeNorm Phase 3: Normalized parser CPU usage.
Phase3PhysIO Phase 3: Total physical I/Os.
Phase3PhysIOKB Phase 3: Total physical I/O usage in KB.
Phase3RSGCPUTime Phase 3: For DSA, RSG CPU usage.
Phase3RSGCPUTimeNorm Phase 3: For DSA, normalized RSG CPU usage.
Phase3StartTime Phase 3: Start time.
Phase3TotalCPUTime Phase 3: Total CPU usage.
Phase3TotalCPUTimeNorm Phase 3: Total normalized CPU usage.
Phase3TotalIO Phase 3: Total logical I/Os.
Phase4EndTime Phase 4: For DSA, the end of the phase.
Phase4IOKB Phase 4: For DSA, the total logical I/O usage in KB.
Phase4ParserCPUTime Phase 4: For DSA, the parser CPU usage.
Phase4ParserCPUTimeNorm Phase 4: For DSA, the normalized parser CPU usage.
Phase4PhysIO Phase 4: For DSA, the total physical I/Os.
Phase4PhysIOKB Phase 4: For DSA, the total physical I/O usage in KB.
Phase4StartTime Phase 4: For DSA, the start of the phase.
Phase4TotalCPUTime Phase 4: For DSA, the total CPU usage.
Phase4TotalCPUTimeNorm Phase 4: For DSA, the total normalized CPU usage.
Phase4TotalIO Phase 4: For DSA, the total logical I/Os.
ProcID Unique processor ID of the Dispatcher and part of the multi-column NUPI for the table (see also CollectTimeStamp column).
ProfileID Profile ID, if any, under which the user submitted the utility job.
ProfileName The name of the profile associated with the log.
ProxyRole Proxy role used for the utility job.
ProxyUser Proxy user for the utility job.
QueryBand Query band under which the utility job is submitted.
RowsDeleted Number of rows deleted.
RowsExported Number of rows exported.
RowsInserted Number of rows inserted.
RowsUpdated Number of rows updated.
SessionID Unique session identifier.
SessionWDID Workload ID class associated with the session. It determines the priority of the session when the Teradata dynamic workload software classification is active.
SysConID Internal identifier of the System Condition (Syscon) / System Health currently enforced by the Teradata dynamic workload management software.
TDWMRuleID ID of the rule that caused a delay.
UserID Unique ID of the user who submitted the utility job.
UserName Name under which the session being logged was initiated.
UtilityName Utility name
UtilityRequest The main utility SQL request for the job. It contains the target database and/or table names. The possible statements are:
  • BEGIN LOADING (FastLoad)
  • BEGIN MLOAD (MLOAD/MLOADX)
  • SELECT (FastExport)
  • DUMP/RESTORE (DSA)
WDID Workload definition assigned to the main utility work.
ZoneID Zone ID of the user who submitted the utility job.