IC89923: AUTOMATIC RUNSTATS MIGHT NOT EVALUATE A TABLE IF DATABASE DEACTIVATION OCCURRED WHILE THE TABLE WAS BEING PROCESSED.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When AUTO_RUNSTATS is enabled for a database, evaluations to
    process tables occur periodically.  If the database is
    deactivated while automatic runstats is processing a table,
    automatic runstats might fail to evaluate the table in future
    evaluations.
    
    To check if the problem has occurred, run:
        SELECT SCHEMA,NAME FROM SYSTOOLS.HMON_ATM_INFO WHERE
    STATS_LOCK != 'N';
        LIST UTILITIES;
    
    The problem has occurred if:
    - the SELECT query returns more than one row, or
    - the SELECT query returns one row when LIST UTILITIES does not
    show an active Automatic runstats
    
    The problem can occur more frequently on, but is not restricted
    to, instances with more than one database enabled for automatic
    runstats.
    

Local fix

  • After a database is activated, as soon as possible before
    automatic maintenance begins, typically about 2 hours after
    activation, manually reset the stats_lock information:
    UPDATE SYSTOOLS.HMON_ATM_INFO SET STATS_LOCK = 'N' WHERE
    STATS_LOCK != 'N'
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to DB2 LUW V9.7 Fixpack 9.                           *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 LUW v9.7 FixPack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC89923

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-30

  • Closed date

    2014-07-30

  • Last modified date

    2014-07-30

  • APAR is sysrouted FROM one or more of the following:

    IC89836

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC89923

Modified date:

2014-07-30

Translate my page

Machine Translation

Content navigation