DSNU1355I csect-name SYSKEYTGTDISTSTATS CATALOG HISTOGRAM STATISTICS FOR index-name KEYSEQ keyseq-num, keyseq-num,... PARTITION part-num QUANTILE quan-num LOWVALUE= X'hex_string' HIGHVALUE= X'hex_string' CARDF = cardinality FREQUENCYF= frequency

Explanation

The RUNSTATS utility issues this message to report the histogram statistics collected for the indexed key column for each quantile, as indicated by quan-num and each partition, as indicated by part-num. If more than one key column is listed, then the statistics collected represent the concatenation of those key columns.

When a value of 1 is specified for NUMCOLS or for default histogram processing, LOWVALUE and HIGHVALUE represent the first key expression value low bound and high bound for each quantile range. If a value greater than 1 is specified for NUMCOLS, then the LOWVALUE and HIGHVALUE represent the concatenation of the key expressions.

cardinality represents the number of distinctive values in each quantile. If more than one key column is listed, then cardinality represents the number of distinctive combinations of that KEYSEQ group in each quantile.

frequency represents the percentage of rows in each quantile.

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

This message is routed to SYSPRINT.