SAP Note 533589 - DB6: SQL2314W Some statistics are in an inconsistent state

Component : DB2 Universal Database for Unix / NT -

Solution : https://service.sap.com/sap/support/notes/533589 (SAP Service marketplace login required)

Summary :
During the execution of database statistics operations, SQL warning code SQL2314W is generated indicating inconsistencies in some statistics. This arises when alterations occur on the target table while statistics are being gathered, impacting the consistency of statistical data across table and index. The warning, which relates to systems using the db6 or db2udb frameworks, does not necessitate any corrective action because updated versions of the dmdb6srp suppress this message, relegating it to a simple notification without operational consequences.

Key words :
terms db2 db6 db2udb udb sql2314 sql2314w reason, sql return code, issued   sql2314w, inconsistent state, affected table, newer versions, statistics run, statistics values, statistics, prerequisites

Related Notes :

1502194DB6: Automatic Statistics Collection (Automatic RUNSTATS)