RUNSTATS Utility (Indexes) panel
You use the RUNSTATS Utility (Indexes) panel to generate utility control statements using the RUNSTATS INDEX form of the RUNSTATS utility.
Panel and field definitions
Process Options Utilities Help
──────────────────────────────────────────────────────────────────────────────
FM/Db2 (DFG2) RUNSTATS Utility (Indexes) Row 1 to 12 of 341
S P Report Update
e R Index Index Part'n Stats Option
l C Owner + Name + Number (Y/N) (A/P/S/N)
fmdb2 TABLE19_UNIQUE 0 N A
fmdb2! TABLE20_UNIQUE 0 N A
thing ix1 0 N A
ARROWSB T1_IX1 0 N A
ARROWSB T3_IX1 0 N A
ARROWSB XDEPT1 0 N A
ARROWSB XDEPT2 0 N A
ARROWSB XDEPT3 0 N A
ARROWSB XEMP1 1 N A
ARROWSB XEMP1 2 N A
ARROWSB XEMP1 3 N A
ARROWSB XEMP1 4 N A
Command ===> Scroll PAGE
F1=Help F2=Split F3=Exit F4=Expand F7=Backward F8=Forward
F9=Swap F10=Left F11=Right F12=Cancel
- Sel
- Selection column. Type
S
to select an index. - PRC
- Processing column. An asterisk (*) indicates the selected index.
- Index Creator
- The name of the creator of the index.
- Index Name
- The name of the index.
- Part'n Number
- The partition number for the index. A zero indicates a non-partitioned index. A non-zero value indicates the partition number of a partitioned index.
- Report Stats (Y/N)
- Whether a report outlining the results of the utility is written
to the SYSPRINT DDNAME:
- Y
- Report written to the SYSPRINT DDNAME.
- N
- Report not written to the SYSPRINT DDNAME. This is the default setting.
- Update Option (A/P/S/N)
- Indicates which catalog tables (if any) are updated by the RUNSTATS
utility. The available options are:
- A
- All. All catalog tables are updated. This is the default setting.
- P
- Access path only. Statistics related to access path selection are updated
- S
- Space only. Only statistics related to space information are updated
- N
- None. No catalog tables are updated.
Parent panels
Child panels
None.