DSNU626I csect-name SYSCOLDISTSTATS CATALOG STATISTICS FOR column-name, column-name, column-name ... PARTITION part-num
CARDINALITY = cardinality
FREQUENCY COLVALUE
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 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.
- 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)