DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.COLGROUPS catalog view

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

Table 1. SYSCAT.COLGROUPS Catalog View
Column Name Data Type Nullable 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   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.