DSNU615I csect-name SYSCOLUMNS CATALOG STATISTICS FOR column-name

Explanation

The RUNSTATS utility issues this message on multiple lines to report the statistics collected for column column-name. Message DSNU619I is issued to identify the table.

COLCARD    =  colcard-value
COLCARDF  = colcardf-value 
HIGH2KEY  = high2key 
LOW2KEY    = low2key

csect-name

The name of the control section that issued the message.

column-name

The name of the column.

colcard-value

This value is set to -1 for most table spaces, and COLCARDF contains the collected statistics value. For non-large table spaces, it is the number of distinct values in the column, as an integer value.

For more information about non-large table spaces, see Table space types and characteristics in Db2 for z/OS.

colcardf-value

The number of distinct values in the column, as a floating point value.

high2key-value

The second highest value of the column.

low2key-value

The second lowest value of the column.

For empty partitions, RUNSTATS sets the values for HIGH2KEY and LOW2KEY to null (''X).