17.00 - Usage Notes - 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

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)