Collecting statistics directly from optimizer output on DB2 11 for z/OS new-function mode

You can get recommended RUNSTATS control statements directly from objects that are listed in the Data Source Explorer, or you can get them by calling the OPT_STAT_ADVICE stored procedure.

If you are tuning an SQL statement or a query workload that runs against DB2 11 for z/OS new-function mode or later, you do not have to run the Statistics Advisor or Workload Statistics Advisor to get recommendations for collecting statistics on objects that are referenced by the SQL statement or query workload.


Feedback