Mainframe Blog

Updatable Catalog Statistics in Db2 12

< 1 minute read
Stephen Watts

(This article is part of our Db2 Guide. Use the right-hand menu to navigate.)

Catalog statistics that updatable and used for access path selection

Table Statistics
SYSIBM.SYSCOLDIST CARDF
COLGROUPCOLNO
COLVALUE
FREQUENCYF
HIGHVALUE
LOWVALUE
NUMCOLUMNS
QUANTILENO
TYPE
SYSIBM.SYSCOLSTATS COLCARD
HIGHKEY
LOWKEY
PARTITION
SYSIBM.SYSCOLUMNS COLCARDF
HIGH2KEY
LOW2KEY
SYSIBM.SYSINDEXES CLUSTERRATIOF
FIRSTKEYCARDF
FULLKEYCARDF
NLEAF
NLEVELS
DATAREPEATFACTORF
SYSIBM.SYSINDEXSTATS DATAREPEATFACTORF
SYSIBM.SYSKEYTARGETS HIGH2KEY
LOW2KEY
STATS_FORMAT
SYSIBM.SYSKEYTGTDIST CARDF
KEYGROUPKEYNO
KEYVALUE
FREQUENCYF
HIGHVALUE
LOWVALUE
NUMKEYS
QUANTILENO
TYPE
SYSIBM.SYSROUTINES CARDINALITY
INITIAL_INSTS
INITIAL_IOS
INSTS_PER_INVOC
IOS_PER_INVOC
SYSIBM.SYSTABLES CARDF
NPAGES
NPAGESF
PCTROWCOMP
SYSIBM.SYSTABLESPACE NACTIVEF
SYSIBM.SYSTABSTATS CARDF
NPAGES

Disclaimer: This Db2® 12 for z/OS Reference Guide was developed to help users in their daily activities in administrating and programming in Db2 for z/OS. There are no guarantees expressed or implied with the contents in this guide. We want to provide a quality and useful reference for users. Please notify us of any mistakes or errors in this reference guide at [email protected]. Db2 is a registered trademark of the IBM Corporation.

Order now! Get your free Db2 collateral from BMC!

Get your free Reference Guide and Catalog Tables Poster for z/OS from BMC. This collateral helps Db2 for z/OS users with daily activities in administering and programming for Db2 on z/OS.


These postings are my own and do not necessarily represent BMC's position, strategies, or opinion.

See an error or have a suggestion? Please let us know by emailing [email protected].

Business, Faster than Humanly Possible

BMC empowers 86% of the Forbes Global 50 to accelerate business value faster than humanly possible. Our industry-leading portfolio unlocks human and machine potential to drive business growth, innovation, and sustainable success. BMC does this in a simple and optimized way by connecting people, systems, and data that power the world’s largest organizations so they can seize a competitive advantage.
Learn more about BMC ›

About the author

Stephen Watts

Stephen Watts (Birmingham, AL) contributes to a variety of publications including, Search Engine Journal, ITSM.Tools, IT Chronicles, DZone, and CompTIA.