Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2004

    Unanswered: Executing Runstats SQL2314W Some Statistics Are in an Inconsistent State

    When executing Runstats I sometimes receive this message:

    SQL2314W Some statistics are in an inconsistent state. The newly collected
    "TABLE" statistics are inconsistent with the existing "INDEX" statistics.

    Can I know from system tables/views which tables issue this message? My idea is to do Runstats first for that tables when less users are working on them.

    DB2 9.7 LUW
    Windows Server 2008

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    maybe large tables - so there is a delay between data stats and index stats and might be there is a slight difference ..because in the mean time rows have been added/deleted...
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Jan 2003
    Provided Answers: 5
    First, this is just a warning. It just means that you table stats and index stats are out of sync. This is usually caused by just doing runstats on just the indexes or just the table. You can figure out which tables are possibly out of sysnc by comparing syscat.tables.stats_time and syscat.indexes.stats_time.

    The best solution is just to do runstats on the table and indexes at the same time with one runstats command.


  4. #4
    Join Date
    Nov 2004
    I am using this command:
    db2 "runstats on table table_name with distribution and detailed indexes all allow write access"

    Do I need to change something so that I can execute Runstats on tables and indexes simultaneously?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts