SYSSTAT.COLDIST catalog view
Each row represents the nth most frequent value of some column, or the nth quantile (cumulative distribution) value of the column. Applies to columns of real tables only (not views). No statistics are recorded for inherited columns of typed tables.
Column Name  Data Type  Nullable  Updatable  Description 

TABSCHEMA  VARCHAR (128)  Schema name of the table to which the statistics apply.  
TABNAME  VARCHAR (128)  Unqualified name of the table to which the statistics apply.  
COLNAME  VARCHAR (128)  Name of the column to which the statistics apply.  
TYPE  CHAR (1) 


SEQNO  SMALLINT  If TYPE = F, n in this column identifies the nth most frequent value. If TYPE = Q, n in this column identifies the nth quantile value. 

COLVALUE^{1}  VARCHAR (254)  Y  Y  Data value as a character literal or a null value. 
VALCOUNT  BIGINT  Y  If TYPE = F, VALCOUNT is the number of occurrences of COLVALUE in the column. If TYPE = Q, VALCOUNT is the number of rows whose value is less than or equal to COLVALUE. 

DISTCOUNT^{2}  BIGINT  Y  Y  If TYPE = Q, this column records the number of distinct values that are less than or equal to COLVALUE (the null value if unavailable). 
Note:
