IBM Support

IC76670: ERROR SQL2312N EXECUTING 'RUNSTATS INDEXES ALL' AGAINST VERY LAR GE TABLE HAVING PARTITIONED INDEXES WHICH HEAPSIZE EXCEEDS 5242

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Whenever the memory reservation computation for runstats local
    indexes exceed 524288 pages, customers will get SQL2312N error
    suggesting the new value to be set. E.g.
    
    SQL2312N  Statistics heap size is too small to carry out the
    operation.
    Suggested heap size is "644578" pages.
    
    In customer scenario they have created table having 2943 range
    partitions and a few partitioned indexes defined on it. They
    received sql2312n when tried the following runstats command
    
     db2 "RUNSTATS ON TABLE "CCDB"."CLAIM_COMMON"  FOR INDEXES
    CCDB"."NEW_IDX_NYT2" allow write access"
    SQL2312N  Statistics heap size is too small to carry out the
    operation.
    Suggested heap size is "644578" pages.
    
    The above problem is encountered only when partitioned indexes
    exist, runstats works fine on non-partitioned indexes.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users using Runstats index all                           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description above                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 FP5 or latest                     *
    ****************************************************************
    

Problem conclusion

  • First fix in DB2 Version 9.7 FP 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC76670

  • 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

    2011-05-27

  • Closed date

    2012-01-17

  • Last modified date

    2012-01-17

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

  • 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



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC76670

Modified date: 17 January 2012