WorkloadStatus - Analytics Database - Teradata Vantage

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: