IBM Support

IC81602: RUNSTATS "FOR INDEXES" CLAUSE RESETS EXISTING RANGE PARTITION TABLE STATISTICS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If runstats is executed on a range partitioned table using the
    "FOR INDEXES" clause, existing partition statistics in
    syscat.datapartitions will be reset to 0.
    
    For example, executing runstats for only 1 index can be done as
    follows :
    
    runstats on table db2inst1.tab1 for detailed index db2inst1.idx1
    
    and the data partition statistics can be retrieved as follows :
    
    select substr(tabname,1,20) as
    tabname,card,npages,fpages,stats_time
    from syscat.datapartitions
    where tabname = 'TAB1'
    
    With this apar, the statistics will show 0 for columns card,
    npages and fpages.
    
    More examples of runstats executions that will have this problem
    :
    runstats on table db2inst1.tab1 for index db2inst1.idx1;
    runstats on table db2inst1.tab1 for detailed indexes all;
    ...
    

Local fix

  • Use the "AND INDEXES" clause, which will collect table
    statistics as well as index statistics.
    e.g. to correct example 1 :
    
    
    runstats on table db2inst1.tab1 AND detailed index
    db2inst1.idx1;
    
    Note this this will slow down runstats execution as table
    statistics are also gathered.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade the DB2 server to V9.7 Fix Pack 6                    *
    ****************************************************************
    

Problem conclusion

  • This problem was first fixed in V9.7 Fix Pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC81602

  • 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

    2012-02-23

  • Closed date

    2012-06-22

  • Last modified date

    2012-06-22

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

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

    IC84440

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
22 June 2012