Creating RUNSTATS profiles
rdheath 120000A31Q Visits (342)
RUNSTATS profiles are sets of options that can be reused by the RUNSTATS utility for maintaining statistics for tables. If you have set up autonomic statistics maintenance, DB2 for z/OS will use the RUNSTATS profiles for the tables that you specify to be within the scope of that maintenance. If you want to run RUNSTATS yourself, you can use RUNSTATS profiles, too.
You can save recommendations from the Workload Statistics Advisor as RUNSTATS profiles. This advisor can recommend RUNSTATS control statements for maintaining the statistics for tables that are important in a database application. After you review the recommendations, with one click you can create new RUNSTATS profiles or update an existing RUNSTATS profile.
To create or update RUNSTATS profiles, your authorization ID must have the STATS privilege or one of the following authorities:
Also, the stored procedure DSNUTILU must be installed and your authorization ID must have the privilege to run it.
This video shows the SYSI
Using RUNSTATS profiles generated by InfoSphere Optim Query Workload Tuner and automating statistics maintenance can not only relieve you of most of the tedium of maintaining statistics. These features can also make it easy to ensure that you are collecting the right statistics. For example, suppose you have set up automatic statistics maintenance, run the Workload Statistics Advisor, and then create a set of RUNSTATS profiles for your application’s tables. Later, some changes are made to one or more of those tables, changes that necessitate different RUNSTATS options for collecting statistics. You can simply run the Workload Statistics Advisor again and update the RUNSTATS profiles with the current recommendations from the advisor.
For information about automating statistics maintenance, see http
For more information about RUNSTATS profiles, see http
UPDATE: developerWorks won't let me set larger dimensions for the embedded video, which means the text of the UI will be hard to see unless you zoom the page.
UPDATE2: Although I can display the video in larger dimensions when I preview this blog entry while editing it, when I post the entry the width is truncated. This apparent bug in the blog makes me think that I might have to post elsewhere than dW if I want to continue creating videos that show how to use the user interface. I'll look into this and let you know what I decide.