Utility Job Log Table: DBQLUtilityTbl - Teradata Database

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

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 method in Priority Scheduler for SUSE Linux Enterprise Server 11 or above. 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

ExpandAcctString

Expanded account name under which the utility job is submitted if account expansion is invoked.

Note: 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

FastExportNoSpool

For utilities implementing FastExport protocol:

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 method in Priority Scheduler for SUSE Linux Enterprise Server 11 or above. 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

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.

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:

WDID

Workload definition assigned to the main utility work.