Supports combined use of the CHECKPOINT and TIMELIMIT options for the INITIATE INDEX ANALYSIS and RESTART INDEX ANALYSIS statements, particularly in the context of submitting an INITIATE INDEX ANALYSIS request that is halted for some reason, followed by one or more RESTART INDEX ANALYSIS requests.
The table provides the following information to support generating index recommendations in this scenario:
The following CREATE TABLE request defines the AnalysisStmts table.
CREATE SET TABLE QCD.AnalysisStmts, NO FALLBACK, NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM=DEFAULT
DEFAULT MERGEBLOCKRATIO(
WorkLoadID INTEGER NOT NULL,
IndexNameTag VARCHAR(128) CHARACTER SET UNICODE
NOT CASESPECIFIC NOT NULL,
RecommendationID INTEGER NOT NULL,
IASeqNumber INTEGER NOT NULL, TimeOfAnalysis TIMESTAMP(6) NOT NULL,
IAStmtText VARCHAR(20000) CHARACTER SET UNICODE
NOT CASESPECIFIC)
PRIMARY INDEX (WorkLoadID);
The following table defines the AnalysisStmts table attributes.
Attribute |
Definition |
WorkLoadID |
|
IndexNameTag |
User-specified name for the index analysis. |
RecommendationID |
Uniquely identifies a set of index recommendations. |
IASeqNumber |
System‑assigned sequence number for this index analysis. |
TimeOfAnalysis |
The timestamp of this index analysis |
IAStmtText |
The SQL text for the request being analyzed. |
See the following topics for further information related to the AnalysisStmts table.