Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2016
    Posts
    17

    Unanswered: Performing run stats on a table

    Hi Everyone,

    I am performing run stats on some tables which has more than 2 crore records. I am using the below command to perform. But almost every time i am getting the below error please suggest me how to over come this ...

    I give allow write access also how to solve it ?

    command:

    db2 " runstats on table <table_name> on all columns and indexes all allow write access "

    Error:

    SQL2314W Some statistics are in an inconsistent state. The newly collected
    "TABLE" statistics are inconsistent with the existing "INDEX" statistics.
    SQLSTATE=01650

  2. #2
    Join Date
    Apr 2012
    Posts
    1,143
    Provided Answers: 27
    That is a warning, it is not an error. Did you follow the recommendations in the documentation? https://www.ibm.com/support/knowledg...sql02314w.html

Posting Permissions

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