16.10 - WorkloadStatus - Teradata Database

Teradata Database SQL Request and Transaction Processing

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
User Guide
featnum
B035-1142-161K

Function of WorkloadStatus

Maintains the status of workloads in the QCD.

This table is maintained by the Teradata Index Wizard.

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 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.