RUNSTATS Utility (Table Spaces) panel

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)          RUNSTATS Utility (Table Spaces)      Row 1 to 12 of 237


 S P          Table                  Indexes Report Update
 e R Database Space    Part'n Number Only    Stats  Option
 l C Name     Name     Number Tables (Y/N)   (Y/N)  (A/P/S/N)
     BILLSDB1 TS1D          0      1   N       N        A
     BILLSDB1 TS1E          1      1   N       N        A
     BILLSDB1 TS1E          2      1   N       N        A
     BILLSDB1 TS1E          3      1   N       N        A
     BILLSDB1 TS1E          4      1   N       N        A
     BILLSDB2 UTILTS1       0      2   N       N        A
     CJMAODA  CJMAOSD       0      1   N       N        A
     CJMAODA  CJMAOSE       1      1   N       N        A
     CJMAODA  CJMAOSE       2      1   N       N        A
     CJMAODA  CJMAOSE       3      1   N       N        A
     CJMAODA  CJMAOSE       4      1   N       N        A
     CJMAODA  CJMAOSP       0      4   N       N        A

 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F12=Cancel

Sel

Selection column. Type S to select a table space.

PRC

Processing column. An asterisk (*) indicates the selected table space.

Database Name

The name of the database in which the table space is defined.

Table Space Name

The name of the table space.

Part'n Number

The partition number for the table space. A zero value indicates a non-partitioned table space; a non-zero value indicates the partition number.

Number Tables

The number of tables in the table space.

Indexes Only (Y/N)

Whether RUNSTATS is performed for only the indexes in the table spaces (without gathering statistics for the tables in the table space itself):

Y

RUNSTATS performed for indexes only.

N

RUNSTATS performed for tables and indexes. This is the default setting.

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:

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.