Updating Db2 columns by DASD MANAGER PLUS
The following tables show the columns in the Db2 catalog that DASD MANAGER PLUS updates.
When the UPDNUCAT installation option is set to N, the parameter indicates that you do not want to update all columns in the Db2 catalog, but only the columns for which Db2 allows updates using SQL. Also, BMCSTATS updates the same columns for ACCESSPATH and SPACE statistics as the IBM RUNSTATS utility.
Table columns that are updated in the Db2 catalog
Table | Columns |
|---|---|
SYSIBM.SYSCOLDIST | CARDF COLGROUPCOLNO COLVALUE FREQUENCY FREQUENCYF HIGHVALUE IBMREQD LOWVALUE NAME NUMCOLUMNS QUANTILENO STATSTIME TBOWNER TBNAME TYPE |
SYSIBM.SYSCOLSTATS | COLCARD HIGHKEY HIGH2KEY LOWKEY LOW2KEY STATS_FORMAT STATSTIME |
SYSIBM.SYSCOLUMNS | COLCARD COLCARDF HIGH2KEY LOW2KEY STATS_FORMAT STATSTIME |
SYSIBM.SYSINDEXES | AVGKEYLEN CLUSTERED CLUSTERRATIO CLUSTERRATIOF DATAREPEATFACTORF FIRSTKEYCARD FIRSTKEYCARDF FULLKEYCARD FULLKEYCARDF NLEAF NLEVELS SPACE SPACEF STATSTIME |
SYSIBM.SYSINDEXPART | AVGKEYLEN CARDF DSNUM EXTENTS FAROFFPOSF LEAFDIST LEAFFAR LEAFNEAR NEAROFFPOSF PQTY PSEUDO_DEL_ENTRIES SECQTYI SPACE SPACEF SQTY STATSTIME |
SYSIBM.SYSKEYTARGETS | CARDF HIGH2KEY LOW2KEY STATS_FORMAT STATSTIME |
SYSIBM.SYSKEYTGTDIST | CARDF FREQUENCYF HIGHVALUE IBMREQD IXSCHEMA IXNAME KEYGROUPKEYNO KEYSEQ KEYVALUE LOWVALUE NUMKEYS QUANTILENO STATSTIME TYPE |
SYSIBM.SYSTABLES | AVGROWLEN CARD CARDF NPAGES NPAGESF PCTPAGES PCTROWCOMP SPACEF STATSTIME |
SYSIBM.SYSTABLEPART | AVGROWLEN CARD CARDF DSNUM EXTENTS FARINDREF NEARINDREF PAGESAVE PERCACTIVE PERCDROP PQTY SECQTYI SPACE SPACEF SQTY STATSTIME |
SYSIBM.SYSTABLESPACE | AVGROWLEN NACTIVE NACTIVEF SPACE SPACEF STATSTIME |
Partitioned Table Space/Index Space Columns Updated in the Db2 Catalog
Partitioned Table/Index Space | Columns |
|---|---|
SYSIBM.SYSCOLDISTSTATS | CARDF COLGROUPCOLNO COLVALUE FREQUENCY FREQUENCYF HIGHVALUE IBMREQD KEYCARDDATA LOWVALUE NAME NUMCOLUMNS PARTITION QUANTILENO STATSTIME TBNAME TBOWNER TYPE |
SYSIBM.SYSINDEXSTATS | CLUSTERRATIO CLUSTERRATIOF FIRSTKEYCARDF FULLKEYCARDF KEYCOUNT KEYCOUNTF NLEAF NLEVELS STATSTIME |
SYSIBM.SYSKEYTARGETSTATS | HIGHKEY HIGH2KEY IBMREQD IXSCHEMA IXNAME KEYSEQ LOWKEY LOW2KEY PARTITION STATSTIME STATS_FORMAT |
SYSIBM.SYSKEYTGTDISTSTATS | CARDF FREQUENCYF HIGHVALUE IBMREQD IXSCHEMA IXNAME KEYGROUPKEYNO KEYSEQ KEYVALUE LOWVALUE NUMKEYS PARTITION QUANTILENO STATSTIME TYPE |
SYSIBM.SYSLOBSTATS | AVGSIZE FREESPACE ORGRATIO STATSTIME |
SYSIBM.SYSTABSTATS | CARD CARDF NACTIVE NPAGES PCTPAGES PCTROWCOMP STATSTIME |