DB2 Version 9.7 for Linux, UNIX, and Windows

SYSSTAT.COLGROUPS catalog view

Each row represents a column group and statistics that apply to the entire column group.

Table 1. SYSSTAT.COLGROUPS Catalog View
Column Name Data Type Nullable Updatable Description
COLGROUPSCHEMA VARCHAR (128)     Schema name of the column group.
COLGROUPNAME VARCHAR (128)     Unqualified name of the column group.
COLGROUPID INTEGER     Identifier for the column group.
COLGROUPCARD BIGINT   Y Cardinality of the column group.
NUMFREQ_VALUES SMALLINT     Number of frequent values collected for the column group.
NUMQUANTILES SMALLINT     Number of quantiles collected for the column group.