SQL Reference

SYSSTAT.COLUMNS

Contains one row for each column for which statistics can be updated. Statistics are not recorded for inherited columns of typed tables.

Table 100. SYSSTAT.COLUMNS Catalog View

Column Name Data Type Nullable Description Updatable
TABSCHEMA VARCHAR(128)
Qualified name of the table that contains the column.
TABNAME VARCHAR(128)

COLNAME VARCHAR(128)
Column name.
COLCARD BIGINT
Number of distinct values in the column; -1 if statistics are not gathered; -2 for inherited columns and columns of H-tables.
For any column, COLCARD cannot have a value higher than the cardinality of the table containing that column.
This column can only be updated with the following values:

-1 or >= 0 (zero)
Yes
HIGH2KEY VARCHAR(33) Yes Second highest value of the column. This field is empty if statistics are not gathered and for inherited columns and columns of H-tables.
This column can be updated with a valid representation of the value appropriate to the column that the statistic is associated with.
LOWKEY2 should not be greater than HIGH2KEY.
Yes
LOW2KEY VARCHAR(33) Yes Second lowest value of the column. Empty if statistics not gathered and for inherited columns and columns of H-tables.
This column can be updated with a valid representation of the value appropriate to the column that the statistic is associated with.
Yes
AVGCOLLEN INTEGER
Average column length. -1 if a long field or LOB, or statistics have not been collected; -2 for inherited columns and columns of H-tables.
This column can only be updated with the following values:

-1 or >= 0 (zero)
Yes

Column Name	Data Type	Nullable	Description	Updatable
TABSCHEMA	VARCHAR(128)		Qualified name of the table that contains the column.
TABNAME	VARCHAR(128)
COLNAME	VARCHAR(128)		Column name.
COLCARD	BIGINT		Number of distinct values in the column; -1 if statistics are not gathered; -2 for inherited columns and columns of H-tables. For any column, COLCARD cannot have a value higher than the cardinality of the table containing that column. This column can only be updated with the following values: -1 or >= 0 (zero)	Yes
HIGH2KEY	VARCHAR(33)	Yes	Second highest value of the column. This field is empty if statistics are not gathered and for inherited columns and columns of H-tables. This column can be updated with a valid representation of the value appropriate to the column that the statistic is associated with. LOWKEY2 should not be greater than HIGH2KEY.	Yes
LOW2KEY	VARCHAR(33)	Yes	Second lowest value of the column. Empty if statistics not gathered and for inherited columns and columns of H-tables. This column can be updated with a valid representation of the value appropriate to the column that the statistic is associated with.	Yes
AVGCOLLEN	INTEGER		Average column length. -1 if a long field or LOB, or statistics have not been collected; -2 for inherited columns and columns of H-tables. This column can only be updated with the following values: -1 or >= 0 (zero)	Yes

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]