DSNU626I csect-name SYSCOLDISTSTATS CATALOG STATISTICS FOR column-name, column-name, column-name ... PARTITION part-num

Explanation

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

The value for CARDINALITY is the number of distinct values for the listed columns. 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 columns.

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

Frequencies for the most frequent values are collected by default, or if the FREQVAL option is 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 column values do not, then the invoker of RUNSTATS is not authorized to read the table. Message DSNU619I is issued to identify the table.

This message is routed to SYSPRINT.

System action

Processing continues.

User response

No action.

Severity

0 (informational)