Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    54

    Red face Unanswered: DB2 9 Express-C with 2Gb, problem with STATISTICS! :-(

    Hi !
    I have a problem when I try to doing the reorg for big table (over than 1 million of rows) , this is the message:

    "
    db2 => REORGCHK UPDATE STATISTICS ON TABLE ALL
    Doing RUNSTATS ....

    SQL2310N The utility could not generate statistics. Error "-668" was
    returned."


    In Message reference I didn't find any user response!! Have any idea?
    I used the configuration Advisor for this schema...
    Fabio

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by petitof
    In Message reference I didn't find any user response!!
    Try looking up SQL0668.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Apr 2004
    Posts
    54

    solved!!

    Thank you! I have found the user response in:
    sqlcode: -668 sqlstate: 57007
    My problem was that the tables was in pending state!

Posting Permissions

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