Accuracy of real-time statistics

In general, the real-time statistics values are very accurate. However, several factors can affect the accuracy of the statistics.

The following factors might affect the accuracy of real-time statistics values:

  • Certain utility restart scenarios.
  • A utility failure that leaves the object in a utility-in-progress state (UTRW, UTRO, or UTUT).
  • Certain utility operations that leave indexes in a database restrictive state, such as RECOVER-pending (RECP). Always consider the database restrictive state of objects before accepting a utility recommendation that is based on real-time statistics.
  • Certain third-party vendor solutions that do not correctly manage real-time statistics.
  • A Db2 subsystem failure.
  • A notify failure in a data sharing environment.

If you think that some statistics values might be inaccurate, you can correct the statistics by invoking the REORG, RUNSTATS, or COPY utilities for the database objects that are described by the inaccurate statistics.