DSNU623I csect-name - catalog-table-name CATALOG NOT UPDATED WITH AGGREGATE STATISTICS FOR object-name BECAUSE SOME PARTITIONS HAVE NO VALID STATISTICS

Explanation

Aggregate statistics were requested, but partition statistics do not exist for every partition. Without partition statistics, the aggregate statistics cannot be calculated. The statistics for object-name are not updated in the specified Db2 catalog table. If you specified UPDATE NONE, then this message will not show up.

One possible cause for this message is that someone altered the length of a varying-length column and then tried to run RUNSTATS with the PART option.

System action

Processing continues.

User response

Run the RUNSTATS utility to collect statistics for:
  • The entire table space, table, column or index, or
  • Every partition.

Severity

4 (warning)