DSNU1352I csect-name SYSKEYTGTDISTSTATS CATALOG STATISTICS FOR index-name KEYSEQ keyseq-num, keyseq-num, ...PARTITION part-num CARDINALITY = cardinality FREQUENCY KEYVALUE = frequency X'hex_string' frequency X'hex_string' ... ... frequency X'hex_string'

Explanation

The RUNSTATS utility issues this message to report the statistics collected for the key column keyseq-num partition part-num. If more than one keyseq-num are listed, then the statistics collected and the expression values reported represent the concatenation of those key columns.

The value of CARDINALITY is the number of distinct values for the listed keyseq-num. This statistic appears only if the KEYCARD option was specified.

The values under FREQUENCY are the same as those that are inserted into the Db2 catalog. Consider each frequency as a four-digit number with an implied decimal point two places to the left of the final digit. The resulting number is the percentage of total rows in the table that contain a particular value for the named index key columns.

Frequency is associated with the occurrence of a single value which is listed under KEYVALUE.

Frequencies for the MOST frequent values are collected by default or if the FREQVAL ... MOST options are specified and given a COUNT value greater than zero.

Frequencies for the LEAST frequent values are collected, if the FREQVAL ... LEAST options are specified and given a COUNT value greater than zero.

Frequencies for the MOST and LEAST frequent values are collected, if the FREQVAL ... BOTH options are specified and given a COUNT value greater than zero.

If the default is taken, then the ten most frequently occurring values, plus the lowest and highest values in the partition (if not already included in the ten greatest frequencies), are reported in descending order of frequency.

If fewer than ten values appear, then there are fewer than ten distinct values in the index.

If no values appear, then the values are uniformly distributed.

If frequencies appear but key column values do not, then the invoker of RUNSTATS is not authorized to read the table. Message DSNU619I is issued to identify the table.

The message is routed to SYSPRINT.