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 catalog tables that RUNSTATS updates 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).
| Keyword | UPDATE option | HISTORY option | Catalog table that RUNSTATS updates |
|---|---|---|---|
| TABLESPACE | UPDATE ALL | HISTORY ALL 4 |
SYSTABLESPACE
SYSTABLEPART1 SYSTABLEPART_HIST1 SYSTABLES1 SYSTABLES_HIST1 SYSTABSTATS1,2 SYSTABSTATS_HIST1,2 SYSLOBSTATS3 SYSLOBSTATS_HIST3 |
| TABLESPACE | UPDATE ALL | HISTORY ACCESSPATH |
SYSTABLESPACE
SYSTABLES1 SYSTABLES_HIST1 SYSTABSTATS1,2 SYSTABSTATS_HIST1,2 |
| TABLESPACE | UPDATE ALL | HISTORY SPACE |
SYSTABLEPART1
SYSTABLEPART_HIST1 SYSLOBSTATS3 SYSLOBSTATS_HIST3 |
| TABLESPACE | UPDATE ACCESSPATH2 | HISTORY ALL 4 |
SYSTABLESPACE
SYSTABLES SYSTABLES_HIST SYSTABSTATS2 SYSTABSTATS_HIST2 |
| TABLESPACE | UPDATE ACCESSPATH2 | HISTORY ACCESSPATH |
SYSTABLESPACE
SYSTABLES SYSTABLES_HIST SYSTABSTATS2 SYSTABSTATS_HIST2 |
| TABLESPACE | UPDATE ACCESSPATH2 | HISTORY SPACE | none |
| TABLESPACE | UPDATE SPACE2 | HISTORY ALL 4 |
SYSTABLEPART
SYSTABLEPART_HIST SYSLOBSTATS3 SYSLOBSTATS_HIST3 SYSTABLES SYSTABLES_HIST |
| TABLESPACE | UPDATE SPACE2 | HISTORY ACCESSPATH | none |
| TABLESPACE | UPDATE SPACE2 | HISTORY SPACE |
SYSTABLEPART
SYSTABLEPART_HIST SYSLOBSTATS3 SYSLOBSTATS_HIST3 SYSTABLES SYSTABLES_HIST |
| TABLE | UPDATE ALL | HISTORY ALL 4 |
SYSCOLUMNS
SYSCOLSTATS2 |
| TABLE | UPDATE ALL | HISTORY ACCESSPATH |
SYSCOLUMNS
SYSCOLSTATS2 |
| TABLE | UPDATE ALL | HISTORY SPACE | none |
| TABLE | UPDATE ACCESSPATH | HISTORY ALL 4 |
SYSCOLUMNS
SYSCOLSTATS2 |
| TABLE | UPDATE ACCESSPATH | HISTORY ACCESSPATH |
SYSCOLUMNS
SYSCOLSTATS2 |
| TABLE | UPDATE ACCESSPATH | HISTORY SPACE | none |
| INDEX | UPDATE ALL | HISTORY ALL 4 |
SYSCOLUMNS
SYSCOLUMNS_HIST SYSCOLDIST SYSCOLDIST_HIST SYSCOLDISTSTATS2 SYSCOLSTATS2 SYSINDEXES SYSINDEXES _HIST SYSINDEXPART SYSINDEXPART_HIST SYSINDEXSTATS2 |
| INDEX | UPDATE ALL | HISTORY ACCESSPATH |
SYSCOLUMNS
SYSCOLUMNS_HIST SYSCOLDIST SYSCOLDIST_HIST SYSCOLDISTSTATS2 SYSCOLSTATS2 SYSINDEXPART SYSINDEXPART_HIST SYSINDEXSTATS2 |
| INDEX | UPDATE ALL | HISTORY SPACE |
SYSINDEXES
SYSINDEXES_HIST |
| INDEX | UPDATE ACCESSPATH | HISTORY ALL 4 |
SYSCOLUMNS
SYSCOLUMNS_HIST SYSCOLDIST SYSCOLDIST_HIST SYSCOLDISTSTATS2 SYSCOLSTATS SYSINDEXES SYSINDEXES _HIST SYSINDEXSTATS2 |
| INDEX | UPDATE ACCESSPATH | HISTORY ACCESSPATH |
SYSCOLUMNS
SYSCOLUMNS_HIST SYSCOLDIST SYSCOLDIST_HIST SYSCOLDISTSTATS2 SYSCOLSTATS SYSINDEXES SYSINDEXES _HIST SYSINDEXSTATS2 |
| INDEX | UPDATE ACCESSPATH | HISTORY SPACE |
SYSINDEXES
SYSINDEXES_HIST |
| INDEX | UPDATE SPACE | HISTORY ALL 4 |
SYSINDEXPART
SYSINDEXPART_HIST SYSINDEXES5 SYSINDEXES_HIST5 |
| INDEX | UPDATE SPACE | HISTORY ACCESSPATH | none |
| INDEX | UPDATE SPACE | HISTORY SPACE |
SYSINDEXPART
SYSINDEXES5 |
| INDEX6 | UPDATE ALL | HISTORY ALL4 |
SYSKEYTARGETS
SYSKEYTARGETS_HIST SYSKEYTARGETSTATS2 SYSKEYTGTDISTSTATS2 SYSINDEXPART SYSINDEXPART_HIST SYSINDEXSTATS2 SYSINDEXSTATS_HIST2 SYSINDEXES SYSINDEXES_HIST SYSKEYTGTDIST SYSKEYTGTDIST_HIST |
| INDEX6 | UPDATE ALL | HISTORY ACCESSPATH |
SYSKEYTARGETS
SYSKEYTARGETS_HIST SYSKEYTARGETSTATS2 SYSKEYTGTDISTSTATS2 SYSINDEXPART SYSINDEXSTATS2 SYSINDEXSTATS_HIST2 SYSINDEXES SYSINDEXES_HIST SYSKEYTGTDIST SYSKEYTGTDIST_HIST |
| INDEX6 | UPDATE ALL | HISTORY SPACE |
SYSKEYTARGETS
SYSKEYTARGETSTATS2 SYSKEYTGTDISTSTATS2 SYSINDEXPART SYSINDEXPART_HIST SYSINDEXSTATS2 SYSINDEXES SYSINDEXES_HIST SYSKEYTGTDIST |
| INDEX6 | UPDATE ACCESSPATH | HISTORY ALL4 |
SYSKEYTARGETS
SYSKEYTARGETS_HIST SYSKEYTARGETSTATS2 SYSKEYTGTDISTSTATS2 SYSINDEXPART SYSINDEXSTATS2 SYSINDEXSTATS_HIST2 SYSINDEXES SYSINDEXES_HIST SYSKEYTGTDIST SYSKEYTGTDIST_HIST |
| INDEX6 | UPDATE ACCESSPATH | HISTORY ACCESSPATH |
SYSKEYTARGETS
SYSKEYTARGETS_HIST SYSKEYTARGETSTATS2 SYSKEYTGTDISTSTATS2 SYSINDEXPART SYSINDEXSTATS2 SYSINDEXSTATS_HIST2 SYSINDEXES SYSINDEXES_HIST SYSKEYTGTDIST SYSKEYTGTDIST_HIST |
| INDEX6 | UPDATE ACCESSPATH | HISTORY SPACE |
SYSKEYTARGETS
SYSKEYTARGETSTATS2 SYSKEYTGTDISTSTATS2 SYSINDEXPART SYSINDEXPART_HIST SYSINDEXSTATS2 SYSINDEXES SYSINDEXES_HIST SYSKEYTGTDIST |
| INDEX6 | UPDATE SPACE | HISTORY ALL4 |
SYSKEYTARGETS_HIST
SYSINDEXPART SYSINDEXSTATS_HIST2 SYSINDEXES SYSINDEXES_HIST SYSKEYTGTDIST_HIST |
| INDEX6 | UPDATE SPACE | HISTORY ACCESSPATH |
SYSINDEXPART
SYSINDEXES SYSINDEXES_HIST |
| INDEX6 | UPDATE SPACE | HISTORY SPACE |
SYSINDEXPART
SYSINDEXPART_HIST SYSINDEXES SYSINDEXES_HIST |
|
Note:
|
|||
RUNSTATS sets the following columns to -1 for universal table spaces and table spaces that are defined as LARGE:
- CARD in SYSTABLES
- CARD in SYSINDEXPART
- FAROFFPOS in SYSINDEXPART
- NEAROFFPOS in SYSINDEXPART
- FIRSTKEYCARD in SYSINDEXES
- FULLKEYCARD in SYSINDEXES