UPDATE-CATSTATS—Update
Db2
System Catalog Statistics

The UPDATE-CATSTATS keyword updates the columns in the Db2 system catalog.
cafrdb2
The UPDATE-CATSTATS keyword updates the columns in the Db2 system catalog. You can use STATS-OPTIONS COLCARD-INDEXED with this keyword to limit the update to indexed columns only.
Review the following considerations:
  • If you specify STATS-OPTIONS COLCARD-INDEXED, COLCARD is updated only for columns that are used in indexes. You can override this setting by specifying STATS-OPTIONS COLCARD-ALL.
  • To update SYSTABLES, SYSCOLUMNS, or SYSINDEXES, you must have previously run PDASTATS or RUNSTATS on the object. PDASTATS is a feature of
    Database Analyzer
    .
  • SYSCOLDIST is updated only with values from the first key column of an index. If multiple indexes have the same first key column, SYSCOLDIST is updated only for the first index.
This keyword has the following format:
UPDATE-CATSTATS [
NONE
|ALL]
  • NONE
    Does not update the Db2 system catalog statistics. This value is the default.
  • ALL
    Updates all columns in the Db2 system catalog.