DSNU632I csect-name- SYSCOLDIST CATALOG HISTOGRAM STATISTICS FOR column-name, column-name, ### QUANTILE quan-num LOWVALUE = X'hex-value' HIGHVALUE = X'hex-value' CARDF = cardf-value FREQUENCYF = frequencyf-value

Explanation

The RUNSTATS utility issues this message to report the histogram statistics that are collected for the specified column or column group for each quantile, as indicated by quan-num.

For single-column, the LOWVALUE and HIGHVALUE represent the column value, low bound and high bound, for each quantile range. For column-group, the LOWVALUE and HIGHVALUE represent the concatenation of those columns.

CARDF represents the number of distinctive values in each quantile. For column group, CARDF represents the number of distinctive combinations of that column group in each quantile.

FREQUENCYF represents the percentage of rows in each quantile.

If the total number of distinctive values for that column or column group is less than the specified number of quantiles, then the quantiles collected is up to the number of distinctive values.

This message is routed to SYSPRINT.