Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Posts
    127

    Unanswered: Runstats warning

    I never had this issue. Runstats threw this warning on a couple of tables. I haven't seen this message in the past. I ran the command as

    db2 runstats on table $TABLE with distribution on all columns and detailed indexes all


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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    That means that the table was being updated during the runstats and the stats are not 100% consistent. For example, the card on the table may not be equal to the fullkeycard on the unique index. Usually nothing to worry about unless you have some reason these need to be in synch (not needed for query optimization).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jun 2003
    Posts
    127
    Thanks. I'm sure that there are no transactions against the database as its in
    quiesce mode. Infact, no IDs have quiesce_connect.

  4. #4
    Join Date
    Jun 2003
    Posts
    127

Posting Permissions

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