Start of change

DSNU1392I csect-name ESTIMATED STATISTICS FOR COLUMN column-name WERE UPDATED IN SYSIBM.SYSCOLUMNS WITH THE FOLLOWING VALUES COLCARD = colcard-value COLCARDF = colcardf-value

Explanation

During statistics processing, the utility detected a discrepancy between the estimated and actual COLCARD and COLCARDF values for the column. The utility corrected those values in SYSIBM.SYSCOLUMNS to reflect the actual values. (DSNU615I reports the estimated values.)

csect-name
The name of the control section that issued the message.
column-name
The name of the column.
colcard-value

The number of distinct values in the column, as an integer value. For large table spaces, the value of the COLCARD column is set to -1. RUNSTATS uses the floating point field COLCARDF to report this statistics value.

All partition-by-growth (PBG) and partition-by-range (PBR) UTS, and partitioned (non-UTS) table spaces with table-controlled partitioning, are considered large table spaces because they use 5-byte RIDs and can contain more than 64 GB of data. For more information, see "Non-large table spaces (deprecated)" in 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.

This message is routed to SYSPRINT.

System action

Processing continues.

User response

No action is required.

Severity

0 (informational)

End of change