17.10 - WorkloadStatus - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Request and Transaction Processing

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
User Guide
Publication ID
B035-1142-171K
Language
English (United States)

Function of WorkloadStatus

Maintains the status of workloads in the QCD using INITIATE INDEX ANALYSIS.

WorkloadStatus Table Definition

The following CREATE TABLE request defines the WorkloadStatus table:

   CREATE TABLE WorkloadStatus (
     WorkloadID         INTEGER NOT NULL,
     RecommendationID   INTEGER,
     IndexNameTag       VARCHAR128 CHARACTER SET UNICODE
                        NOT CASESPECIFIC,
     ValidatedSystem    VARCHAR(30) CHARACTER SET UNICODE
                        NOT CASESPECIFIC,
     ValidatedTimeStamp TIMESTAMP(6),
     ValidatedQCD       VARCHAR128 CHARACTER SET UNICODE
                        NOT CASESPECIFIC,
     RecosAppliedSystem VARCHAR(30) CHARACTER SET UNICODE
                        NOT CASESPECIFIC,
     Remarks            VARCHAR(20000) CHARACTER SET UNICODE
                        NOT CASESPECIFIC)
   UNIQUE PRIMARY INDEX (WorkloadID ,IndexNameTag);

Attribute Definitions for WorkloadStatus

The following table defines the WorkloadStatus table attributes:

Attribute Definition
WorkloadID
  • Unique identifier for the workload.
  • Partial UPI for the table.
RecommendationID Unique identifier for the set of indexes recommended for this workload after an index analysis.
IndexNameTag
  • Name of the index recommendation as specified in the INITIATE INDEX ANALYSIS statement (see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144).
  • Partial UPI for the table.
ValidatedSystem Name of the system on which index recommendations are last validated.
ValidatedTimeStamp Timestamp of the index validation.
ValidatedQCD Name of the QCD on which the validation is performed.
RecosAppliedSystem Name of the system on which index recommendations are last created.
Remarks Free form textual remarks about the workload.