Results 1 to 2 of 2
  1. #1
    Join Date
    May 2010
    Posts
    88

    Unanswered: runstats generating logs

    Hello everybody,
    I am working on db2 v9.1 on AIx 5.3.
    We have scheduled the RUNSTATS script to be executed on every sunday which generates huge number of logs and thus consumes much of the disk space. My question is:
    1. How are these logs generated during RUNSTATS execution helpful?
    2. If not usefull at all, how can we force RUNSTATS utility not to create them?

    Also attached is the script for your reference.
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    1. Yes!
    2. I've never noticed runstats to generate a lot of logs AND I've never used the "sampled detailed indexes" option. Try runstats without that option and see if that makes a difference. Are your tables that big that you really need sampling?

Posting Permissions

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