SQL2314W SQLSTATE=01650 runstats issue in db2


Error:

db2 "runstats on table <SCHEMA_NAME>.<TABLE_NAME>"

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




Solution:

db2 "runstats on table on <SCHEMA_NAME>.<TABLE_NAME> all columns with distribution on all columns and sampled detailed indexes all allow write access"

DB20000I  The RUNSTATS command completed successfully.

2 comments:

  1. I run the command above, it populated error so I run it like this:
    db2 "runstats on table . on all columns and sampled detailed indexes all allow write access"
    and after that I executed runstats on . and it worked. Thanks for the help, Ajay

    ReplyDelete
  2. hostname> db2 runstats on table <> and indexes all
    SQL2314W Some statistics are in an inconsistent state. The newly collected
    "TABLE" statistics are inconsistent with the existing "INDEX" statistics.
    SQLSTATE=01650


    db2 "runstats on table <> on all columns and sampled detailed indexes all allow write access" is working fine. thanks for your support.

    ReplyDelete