Results 1 to 4 of 4

Thread: runstats

  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Unanswered: runstats

    Hello,

    I am using DB2 8.1.3 on unix AIX,

    I have tables that creates and loaded every day from text file.

    we are doing "runstats on table TABLE with distribution and detailed indexes all".

    one day the load was from ixf file and then the runstats not work.
    and the response time from the table was very bad

    my question is why at DB2 7 we not have this problem any time
    perhaps tuning problem?


    Please help me!!

    Regards,

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    Can you post erorr message?

    Grofaty

  3. #3
    Join Date
    Mar 2004
    Posts
    4
    hello !

    the loading finished good and the script not doing runstats if ther is ixf file

    the fact was very slowly to our web site until we doing runstats manually
    and we didn't get any error , and at version 7 we hadn't this problem

    thank you

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I would suggest you report this to IBM ...

    BTW, are you replacing the data with LOAD REPLACE ??? IF yes, you can collect the statistics as a part of the LOAD itself ... I think it is faster than doing a RUNSTATS on its own

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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