Use the Data Source Explorer to gather RUNSTATS recommendations directly from subsystems,
schemas, or tables.
Procedure
- In the Data Source Explorer view, connect to the DB2 for z/OS subsystem on which are located
the objects that you want to collect statistics for.
- Expand the connection to view the subsystem icon.
- To generate RUNSTATS recommendations for collecting statistics for all tables that are in
the subsystem, right-click the subsystem icon and select .
- To generate RUNSTATS recommendations for collecting statistics for all tables that are in
one or more schemas, expand the subsystem until you find the schema or schemas that you want. Select
them, right-click them, and select .
- To generate RUNSTATS recommendations for collecting statistics for one or more tables,
expand the subsystem until you find the table or tables that you want. Select them, right-click
them, and select .
Results
The RUNSTATS recommendations are generated and the
Collect Statistics
window opens. You can choose to whether to remove RUNSTATS recommendations for any objects and then
run the remaining recommendations.