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 |
|
| RecommendationID | Unique identifier for the set of indexes recommended for this workload after an index analysis. |
| IndexNameTag |
|
| 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. |