Collecting Statistics by using the Data Source Explorer

Use the Data Source Explorer to gather RUNSTATS recommendations directly from subsystems, schemas, or tables.

About this task

Procedure

  1. 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.
  2. 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 Analyze and Tune > Collect Statistics.
    • 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 Analyze and Tune > Collect Statistics.
    • 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 Analyze and Tune > Collect Statistics.

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.