SYSCOLDIST_HIST catalog table
The SYSCOLDIST_HIST catalog table contains rows from the SYSCOLDIST catalog table. The schema is SYSIBM.
Rows are added or changed in this table when RUNSTATS collects history statistics. Rows in this table can also be inserted, updated, and deleted.
| Column name | Data type | Description | Use |
|---|---|---|---|
| STATSTIME | TIMESTAMP
NOT NULL |
|
G |
| TBOWNER | VARCHAR(128)
NOT NULL |
The schema of the table that contains the column. |
G |
| TBNAME | VARCHAR(128)
NOT NULL |
Name of the table that contains the column. | G |
| NAME | VARCHAR(128)
NOT NULL |
Name of the column. If NUMCOLUMNS is greater than 1, this name identifies the first column name of the set of columns associated with the statistics. | G |
| COLVALUE | VARCHAR(2000)
NOT NULL FOR BIT DATA |
Contains the data of a frequently occurring value. Statistics are not collected for an index on a ROWID column. If the value has a non-character data type, the data might not be printable. | S |
| TYPE | CHAR(1)
NOT NULL WITH DEFAULT 'F' |
The type of statistics gathered:
|
G |
| CARDF | FLOAT(8)
NOT NULL WITH DEFAULT -1 |
When TYPE='C', this is the number of distinct values for the column group. When TYPE='H', this is he number of distinct values for the column group in a quantile indicated by QUANTILENO. The value is -1 if statistics have not been gathered. |
S |
| COLGROUPCOLNO | VARCHAR(254)
NOT NULL FOR BIT DATA |
Identifies the set of columns associated with the statistics. If the statistics are only associated with a single column, the field contains a zero length. Otherwise, the field is an array of SMALLINT column numbers with a dimension equal to the value in NUMCOLUMNS. | S |
| NUMCOLUMNS | SMALLINT
NOT NULL WITH DEFAULT 1 |
Identifies the number of columns associated with the statistics. | G |
| FREQUENCYF | FLOAT(8)
NOT NULL DEFAULT -1 |
Gives the percentage of rows in the table with the value specified in COLVALUE when the number is multiplied by 100. For example, a value of '1' indicates 100%. A value of '.153' indicates 15.3%. When TYPE='H', this is the percentage of rows in table which falls in the quantile indicated by QUANTILENO whose range is limited by [LOWVALUE, HIGHVALUE]. Statistics are not collected for an index on a ROWID column. The value is -1 if statistics have not been gathered. |
G |
| IBMREQD | CHAR(1)
NOT NULL DEFAULT 'N' |
A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators. The value in this field is not a reliable indicator of release dependencies. |
G |
| QUANTILENO | SMALLINT
NOT NULL WITH DEFAULT -1 |
Ordinary sequence number of a quantile in the whole consecutive value range, from low to high. This column is not updatable. | G |
| LOWVALUE | VARCHAR(2000)
NOT NULL WITH DEFAULT FOR BIT DATA |
For TYPE='H', this is the lower bound for the quantile indicated by QUANTILENO. Not used if TYPE is not 'H'. This column is not updatable. | G |
| HIGHVALUE | VARCHAR(2000)
NOT NULL WITH DEFAULT FOR BIT DATA |
For TYPE='H', this is the higher bound for the quantile indicated by QUANTILENO. Not used if TYPE is not 'H'. This column is not updatable. | G |
If RUNSTATS or another utility with inline statistics updated the statistics, the date and time when the last utility invocation updated the statistics. The default value is '0001-01-01-00.00.00.000000'. The default value indicates that statistics were not collected. This column can be updated.