Results 1 to 9 of 9
  1. #1
    Join Date
    Apr 2009
    Posts
    42

    Unanswered: automatic runstats

    Hello

    What parameters does DB2 use to perform automatic runstats? Does it collect distribution or index statistics?

    Thank you!

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by db2zip
    Does it collect distribution or index statistics?
    I don't think it does, unless you have the appropriate statistics profile in place for the table.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Apr 2009
    Posts
    42
    Will automatic runstats execute without any parameters by default? runstats on table table-name?

  4. #4
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    For this you'll need the new option "SET PROFILE". The runstats generated by automatic runstats will use your pre-defined profile for each table.

  5. #5
    Join Date
    Apr 2009
    Posts
    42
    Quote Originally Posted by dr_te_z
    The runstats generated by automatic runstats will use your pre-defined profile for each table.

    What parameters will it use if I do not have pre-defined profile?

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Auto runstats uses "with distribution and sampled detailed indexes all" if there is no profile set for the table

  7. #7
    Join Date
    Apr 2009
    Posts
    42
    Thank you! Where can I find information about this? I don't see in DB2 manual.

  8. #8
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    I don't think this info is in the manuals. I'll see if there is a technote on this.

  9. #9
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by db2zip
    Where can I find information about this? I don't see in DB2 manual.
    Automatic statistics collection

    "By default, the statistics that are collected are basic table statistics with distribution information, and detailed index statistics using sampling (RUNSTATS options WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL). You can customize the type of statistics collected by enabling statistics profiling, which uses information about previous database activity to determine which statistics are required by the database workload."
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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