Usage Notes - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

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

Phases

The following table describes the different column phases shown in QryLogUtilityV:

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.

Possible Values for CPUDecayLevel

CPUDecayLevel is the decay level reached for CPU usage per AMP, for requests using the default Timeshare workload management method. Possible values are:

Value Description
0 Indicates that the request is running at the default priority.
1 Indicates that the priority level is reduced and the resource allotment is halved.
2 Indicates that the priority level is reduced again, the resource allotment is halved again, and it will not be reduced more.

Possible Values for IODecayLevel

IODecayLevel is the decay level reached for I/O usage per AMP, for requests using the default Timeshare workload management method.

Value Description
0 Indicates that the request is running at the default priority.
1 Indicates that the priority level is reduced and the resource allotment is halved.
2 Indicates that the priority level is reduced again, the resource allotment is halved again, and it will not be reduced more.

Possible Values for 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.

Possible Values for UtilityRequest

UtilityRequest is 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)