15.10 - WorkloadStatus - Teradata Database

Teradata Database SQL Request and Transaction Processing

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
User Guide
featnum
B035-1142-151K

Maintains the status of workloads in the QCD.

This table is maintained by the Teradata Index Wizard.

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);

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 SQL Data Definition Language).
  • Partial UPI for the table.
  • ValidatedSystem

    Name of the system on which index recommendations are last validated by the Teradata Index Wizard.

    ValidatedTimeStamp

    Timestamp of the index validation.

    ValidatedQCD

    Name of the QCD on which the validation is performed by the Teradata Index Wizard.

    RecosAppliedSystem

    Name of the system on which index recommendations are last created by the Teradata Index Wizard.

    Remarks

    Free form textual remarks about the workload.