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. UnknownJune 11, 2014 at 6:51 PM

    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. UnknownMarch 15, 2018 at 11:15 AM

    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