Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: Question about statistics in a table DB2 8.1

    Hi Colleagues,

    I am executing statistics to a table of size 20 gb and need to know how long remains to finish the execution?

    Thank you for advanced.

  2. #2
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    Hi Colleagues,
    somebody can say something to me about this subject, please?

    Thank you for you help.

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    sorry but list utilities does not show this for runstats..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  4. #4
    Join Date
    Nov 2011
    Posts
    334
    This depends on how many colunms you collected stats on
    and column type ,length, data content ,index numbers on the table if used "with distribution" and "detailed indexs" clause。
    io capability, cpu frequency will also be factors which affect the execution time
    So no one can tell you the quick answer。

  5. #5
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    Thank you for your answers, what in the table where is this information?

    Thank you.

Posting Permissions

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