RUNSTATS Utility (Table Spaces) panel
You use the RUNSTATS Utility (Table Spaces) panel to generate either RUNSTATS TABLESPACE or RUNSTATS INDEX control statements, depending on the value selected for the Indexes Only column.
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.
- 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.
Parent panels
Child panels
None.