Review of RUNSTATS output

The RUNSTATS utility updates columns in the catalog tables. When you specify REPORT YES, the RUNSTATS utility also generates a report of the statistics that it gathered.

The following table shows the statistics that RUNSTATS updates in the catalog tables depending on the value of the UPDATE option, the value of the HISTORY option, and the source of the statistics (table space, partition, index or LOB table space).

Table 1. Catalog tables that RUNSTATS updates
Keyword	UPDATE option	HISTORY option	Catalog table that RUNSTATS updates
TABLESPACE	UPDATE ALL	HISTORY ALL ⁴	SYSTABLESPACE SYSTABLEPART¹ SYSTABLEPART_HIST¹ SYSTABLES¹ SYSTABLES_HIST¹ SYSTABSTATS^1,2 SYSTABSTATS_HIST^1,2 SYSLOBSTATS³ SYSLOBSTATS_HIST³
TABLESPACE	UPDATE ALL	HISTORY ACCESSPATH	SYSTABLESPACE SYSTABLES¹ SYSTABLES_HIST¹ SYSTABSTATS^1,2 SYSTABSTATS_HIST^1,2
TABLESPACE	UPDATE ALL	HISTORY SPACE	SYSTABLEPART¹ SYSTABLEPART_HIST¹ SYSLOBSTATS³ SYSLOBSTATS_HIST³
TABLESPACE	UPDATE ACCESSPATH²	HISTORY ALL ⁴	SYSTABLESPACE SYSTABLES SYSTABLES_HIST SYSTABSTATS² SYSTABSTATS_HIST²
TABLESPACE	UPDATE ACCESSPATH²	HISTORY ACCESSPATH	SYSTABLESPACE SYSTABLES SYSTABLES_HIST SYSTABSTATS² SYSTABSTATS_HIST²
TABLESPACE	UPDATE ACCESSPATH²	HISTORY SPACE	none
TABLESPACE	UPDATE SPACE²	HISTORY ALL ⁴	SYSTABLEPART SYSTABLEPART_HIST SYSLOBSTATS³ SYSLOBSTATS_HIST³ SYSTABLES SYSTABLES_HIST
TABLESPACE	UPDATE SPACE²	HISTORY ACCESSPATH	none
TABLESPACE	UPDATE SPACE²	HISTORY SPACE	SYSTABLEPART SYSTABLEPART_HIST SYSLOBSTATS³ SYSLOBSTATS_HIST³ SYSTABLES SYSTABLES_HIST
TABLE	UPDATE ALL	HISTORY ALL ⁴	SYSCOLUMNS SYSCOLSTATS²
TABLE	UPDATE ALL	HISTORY ACCESSPATH	SYSCOLUMNS SYSCOLSTATS²
TABLE	UPDATE ALL	HISTORY SPACE	none
TABLE	UPDATE ACCESSPATH	HISTORY ALL ⁴	SYSCOLUMNS SYSCOLSTATS²
TABLE	UPDATE ACCESSPATH	HISTORY ACCESSPATH	SYSCOLUMNS SYSCOLSTATS²
TABLE	UPDATE ACCESSPATH	HISTORY SPACE	none
INDEX	UPDATE ALL	HISTORY ALL ⁴	SYSCOLUMNS SYSCOLUMNS_HIST SYSCOLDIST SYSCOLDIST_HIST SYSCOLDISTSTATS² SYSCOLSTATS² SYSINDEXES SYSINDEXES _HIST SYSINDEXPART SYSINDEXPART_HIST SYSINDEXSTATS²
INDEX	UPDATE ALL	HISTORY ACCESSPATH	SYSCOLUMNS SYSCOLUMNS_HIST SYSCOLDIST SYSCOLDIST_HIST SYSCOLDISTSTATS² SYSCOLSTATS² SYSINDEXPART SYSINDEXPART_HIST SYSINDEXSTATS²
INDEX	UPDATE ALL	HISTORY SPACE	SYSINDEXES SYSINDEXES_HIST
INDEX	UPDATE ACCESSPATH	HISTORY ALL ⁴	SYSCOLUMNS SYSCOLUMNS_HIST SYSCOLDIST SYSCOLDIST_HIST SYSCOLDISTSTATS² SYSCOLSTATS SYSINDEXES SYSINDEXES _HIST SYSINDEXSTATS²
INDEX	UPDATE ACCESSPATH	HISTORY ACCESSPATH	SYSCOLUMNS SYSCOLUMNS_HIST SYSCOLDIST SYSCOLDIST_HIST SYSCOLDISTSTATS² SYSCOLSTATS SYSINDEXES SYSINDEXES _HIST SYSINDEXSTATS²
INDEX	UPDATE ACCESSPATH	HISTORY SPACE	SYSINDEXES SYSINDEXES_HIST
INDEX	UPDATE SPACE	HISTORY ALL ⁴	SYSINDEXPART SYSINDEXPART_HIST SYSINDEXES⁵ SYSINDEXES_HIST⁵
INDEX	UPDATE SPACE	HISTORY ACCESSPATH	none
INDEX	UPDATE SPACE	HISTORY SPACE	SYSINDEXPART SYSINDEXES⁵
INDEX⁶	UPDATE ALL	HISTORY ALL⁴	SYSKEYTARGETS SYSKEYTARGETS_HIST SYSKEYTARGETSTATS² SYSKEYTGTDISTSTATS² SYSINDEXPART SYSINDEXPART_HIST SYSINDEXSTATS² SYSINDEXSTATS_HIST² SYSINDEXES SYSINDEXES_HIST SYSKEYTGTDIST SYSKEYTGTDIST_HIST
INDEX⁶	UPDATE ALL	HISTORY ACCESSPATH	SYSKEYTARGETS SYSKEYTARGETS_HIST SYSKEYTARGETSTATS² SYSKEYTGTDISTSTATS² SYSINDEXPART SYSINDEXSTATS² SYSINDEXSTATS_HIST² SYSINDEXES SYSINDEXES_HIST SYSKEYTGTDIST SYSKEYTGTDIST_HIST
INDEX⁶	UPDATE ALL	HISTORY SPACE	SYSKEYTARGETS SYSKEYTARGETSTATS² SYSKEYTGTDISTSTATS² SYSINDEXPART SYSINDEXPART_HIST SYSINDEXSTATS² SYSINDEXES SYSINDEXES_HIST SYSKEYTGTDIST
INDEX⁶	UPDATE ACCESSPATH	HISTORY ALL⁴	SYSKEYTARGETS SYSKEYTARGETS_HIST SYSKEYTARGETSTATS² SYSKEYTGTDISTSTATS² SYSINDEXPART SYSINDEXSTATS² SYSINDEXSTATS_HIST² SYSINDEXES SYSINDEXES_HIST SYSKEYTGTDIST SYSKEYTGTDIST_HIST
INDEX⁶	UPDATE ACCESSPATH	HISTORY ACCESSPATH	SYSKEYTARGETS SYSKEYTARGETS_HIST SYSKEYTARGETSTATS² SYSKEYTGTDISTSTATS² SYSINDEXPART SYSINDEXSTATS² SYSINDEXSTATS_HIST² SYSINDEXES SYSINDEXES_HIST SYSKEYTGTDIST SYSKEYTGTDIST_HIST
INDEX⁶	UPDATE ACCESSPATH	HISTORY SPACE	SYSKEYTARGETS SYSKEYTARGETSTATS² SYSKEYTGTDISTSTATS² SYSINDEXPART SYSINDEXPART_HIST SYSINDEXSTATS² SYSINDEXES SYSINDEXES_HIST SYSKEYTGTDIST
INDEX⁶	UPDATE SPACE	HISTORY ALL⁴	SYSKEYTARGETS_HIST SYSINDEXPART SYSINDEXSTATS_HIST² SYSINDEXES SYSINDEXES_HIST SYSKEYTGTDIST_HIST
INDEX⁶	UPDATE SPACE	HISTORY ACCESSPATH	SYSINDEXPART SYSINDEXES SYSINDEXES_HIST
INDEX⁶	UPDATE SPACE	HISTORY SPACE	SYSINDEXPART SYSINDEXPART_HIST SYSINDEXES SYSINDEXES_HIST
Note: Not applicable if the specified table space is a LOB table space. Only updated for partitioned objects. When you run RUNSTATS against single partitions of an object, RUNSTATS uses the partition-level statistics to update the aggregate statistics for the entire object. These partition-level statistics are contained in the following catalog tables: SYSCOLSTATS SYSCOLDISTSTATS SYSTABSTATS SYSINDEXSTATS Applicable only when the specified table space is a LOB table space. When HISTORY NONE is specified, none of the catalog history tables are updated. Only the SPACEF and STATSTIME columns are updated. Applicable only when the target object is an expression-based index.

RUNSTATS sets the following integer column values to -1 for most table spaces, and it reports the collected statistic in a corresponding floating point column. (For example, CARDF is the corresponding floating point column for CARD.) The integer columns are set to meaningful values only for non-large table spaces. For more information about non-large table spaces, see Table space types and characteristics in Db2 for z/OS.

COLCARD in SYSCOLUMNS
FREQUENCY in SYSCOLDIST
FREQUENCY in SYSCOLDISTSTATS
CARD in SYSTABLES
FIRSTKEYCARD and FULLKEYCARD in SYSINDEXES
CARD, FAROFFPOS, and NEAROFFPOS in SYSINDEXPART

Additionally, after RUNSTATS TABLESPACE completes successfully, the utility updates the COMPRESS_USED column of the SYSTABLEPART catalog table with the type of the compression dictionary that is in effect on each target page set.