RUNSTATS 出力の検討
RUNSTATS ユーティリティーは、カタログ表の列を更新します。 REPORT YES を指定すると、RUNSTATS ユーティリティーは、収集した統計の報告書も生成します。
次の 表は、UPDATE オプションの値、HISTORY オプションの値、および統計のソース (表スペース、パーティション、索引、または LOB 表スペース) に 応じて、RUNSTATS が更新するカタログ表を示します。
| キーワード | UPDATE のオプション | HISTORY オプション | RUNSTATS が更新するカタログ表 |
|---|---|---|---|
| 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 | なし |
| TABLESPACE | UPDATE SPACE2 | HISTORY ALL 4 | SYSTABLEPART
SYSTABLEPART_HIST SYSLOBSTATS3 SYSLOBSTATS_HIST3 SYSTABLES SYSTABLES_HIST |
| TABLESPACE | UPDATE SPACE2 | HISTORY ACCESSPATH | なし |
| 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 | なし |
| TABLE | UPDATE ACCESSPATH | HISTORY ALL 4 | SYSCOLUMNS
SYSCOLSTATS2 |
| TABLE | UPDATE ACCESSPATH | HISTORY ACCESSPATH | SYSCOLUMNS
SYSCOLSTATS2 |
| TABLE | UPDATE ACCESSPATH | HISTORY SPACE | なし |
| 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 | なし |
| INDEX | UPDATE SPACE | HISTORY SPACE | SYSINDEXPART
SYSINDEXES5 |
| INDEX6 | UPDATE ALL | HISTORY ALL 4 | 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 ALL 4 | 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 ALL 4 | 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 |
注:
|
|||
RUNSTATS は、ユニバーサル表スペースおよび LARGE として定義された表スペースについては、以下の列を -1 に設定します。
- SYSTABLES の CARD
- SYSINDEXPART の CARD
- SYSINDEXPART の FAROFFPOS
- SYSINDEXPART の NEAROFFPOS
- SYSINDEXES の FIRSTKEYCARD
- SYSINDEXES の FULLKEYCARD