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.

For more information, see the DB2 Utility Guide and Reference.

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

Db2 Utilities panel

Child panels

None.

Related tasks

RUNSTATS (indexes)