DB2 Version 9.7 for Linux, UNIX, and Windows

SYSSTAT.COLGROUPDIST catalog view

Each row represents the value of the column in a column group that makes up the nth most frequent value of the column group or the nth quantile value of the column group.

Table 1. SYSSTAT.COLGROUPDIST Catalog View
Column Name Data Type Nullable Updatable Description
COLGROUPID INTEGER     Identifier for the column group.
TYPE CHAR (1)    
  • F = Frequency value
  • Q = Quantile value
ORDINAL SMALLINT     Ordinal number of the column in the column group.
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 VARCHAR (254) Y Data value as a character literal or a null value.