Troubleshooting
Problem
db2 "runstats on table TSMDB1.TSM_TABLE_ONE on all columns with distribution and index all" fails with
SQL2314W Some statistics are in an inconsistent state. The newly collected "TABLE" statistics are
inconsistent with the existing "INDEX" statistics SQLSTATE=01650
Cause
Incorrect Runstats command was run. The option ALLOW READ ACCESS was not part of the Runstats command.
Diagnosing The Problem
You may be running into this problem if you run a Runstats command similar to the following:
$ db2 "runstats on table TSMDB1.TSM_TABLE_ONE on all columns with distribution and index all"
You may get the following error message returned:
SQL2314W Some statistics are in an inconsistent state. The newly collected "TABLE" statistics are inconsistent with the existing "INDEX" statistics. SQLSTATE=01650
Resolving The Problem
To resolve the problem, you need to add the option ALLOW READ ACCESS to the command
For example:
$ db2 "runstats on table TSMDB1.TSM_TABLE_ONE on all columns with distribution and index all allow read access"
DB20000I The RUNSTATS command completed successfully.
DB20000I The RUNSTATS command completed successfully.
Document Location
Worldwide
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEQVQ","label":"IBM Spectrum Protect"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Was this topic helpful?
Document Information
Modified date:
10 May 2021
UID
ibm10869802