SYSIBM.SYSCOLDIST_HIST table
The SYSIBM.SYSCOLDIST_HIST table contains rows from SYSCOLDIST.
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 |
If RUNSTATS updated the statistics, the date and time when the last invocation of RUNSTATS updated the statistics. The default value is '0001-01-01-00.00.00.000000'. The default value indicates that statistics were not collected. This is an updatable column. |
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
came from the basic machine-readable material (MRM) tape. 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 |