Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2009
    Posts
    6

    Unanswered: DB2 Runstats !!!!

    Can anyone please let me know benefit of using "set profile" clause in runstats command n db29.7 fp4?

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    the benefit is that it lets you make a customised runstats for a table or tables.
    Occasionally you need specific kinds of sampling on different columns, different kinds of stats on different columns, different column-group stats.
    It is convenient to have all those customised options collected as a profile.

  3. #3
    Join Date
    Oct 2009
    Posts
    6
    Thanks for your reply.

    I ran the below query for setting the profile.

    runstats on table <table_name> with distribution and detailed indexes all set profile;

    And database is enabled for automatic maintenance. Does it mean whenever the database will call the automatic runstats it will use the above set profile?

  4. #4
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18

  5. #5
    Join Date
    Oct 2009
    Posts
    6
    Thanks for the link. I have already studied that before posting my query. My doubt is whether the db2 automatic runstats will use the previously stored profile which I set up?

  6. #6
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •