image_pdfimage_print

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 blogs@bmc.com. 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.
Order Now ›
Last updated: 04/01/2019

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 blogs@bmc.com.

About the author

Stephen Watts

Stephen Watts

Stephen Watts (Birmingham, AL) has worked at the intersection of IT and marketing for BMC Software since 2012.

Stephen contributes to a variety of publications including CIO.com, Search Engine Journal, ITSM.Tools, IT Chronicles, DZone, and CompTIA.

Run and Reinvent Your Business with BMC

BMC has unmatched experience in IT management, supporting 92 of the Forbes Global 100, and earning recognition as an ITSM Gartner Magic Quadrant Leader for six years running. Our solutions offer speed, agility, and efficiency to tackle business challenges in the areas of service management, automation, operations, and the mainframe. Learn more about BMC ›