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.

1 comment:

  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