Usage Notes - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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 Request is running at default priority.
1 Priority level is reduced and resource allotment is halved.
2 Priority level is reduced again, resource allotment is halved again. No future reductions.

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 Request is running at default priority.
1 Priority level is reduced and resource allotment is halved.
2 Priority level is reduced again, resource allotment is halved again. No future reductions.

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, and contains the target database or table names. The possible statements are:
  • BEGIN LOADING (FastLoad)
  • BEGIN MLOAD (MLOAD/MLOADX)
  • SELECT (FastExport)
  • DUMP/RESTORE (DSA)