IBM Support

IC70474: DB2 MAY ABEND DUE TO MEMORY CORRUPTION WHILE ESTIMATING STATISTICS.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 may terminate abnormally upon detecting memory corruption.
    This can happen if the query is complex with numerous tables and
    local range predicates. The problem does not happen if there is
    no local range predicate in the query.
    The stack trace might look as follows:
    
      [0] 0x00002AEB54D36B9B pdLog + 0xD7
      [1] 0x00002AEB563C061D
    /opt/IBM/dwe/db2/V9.5/lib64/libdb2e.so.1 + 0x275661D
      [2] 0x00002AEB56F63EB5 sqlofmblkEx + 0x8B9
      [3] 0x00002AEB54D208AC _Z9sqlofmblkPv + 0x6
      [4] 0x00002AEB562354D1
    _Z23sqlnr_estimate_sel_cardP9sqlnq_oprP17sqlnq_qtbElemListP17sql
    nq_prdElemListiiRfS5_RiP3loc
    + 0x152B
      [5] 0x00002AEB5623D3E3
    _Z23sqlnr_estimate_box_cardP9sqlnq_qtbP17sqlnq_qtbElemListP17sql
    nq_prdElemListiiRfS5_RiP3loc
    + 0x2EB
      [6] 0x00002AEB5623C80D
    _Z19sqlnr_estimate_cardP9sqlnq_qtbP17sqlnq_qtbElemListP17sqlnq_p
    rdElemListiiP18sqlnr_qtbStatsListRiP3loc
    + 0x79D
      [7] 0x00002AEB5618563F
    /opt/IBM/dwe/db2/V9.5/lib64/libdb2e.so.1 + 0x251B63F
      [8] 0x00002AEB56188FCE
    _Z26sqlnr_joinppd_magic_detailP10sqlnr_qrwaPiP14sqlnr_progress +
    0x1038
      [9] 0x00002AEB5618BFF7
    _Z20sqlnr_joinppd_actionP10sqlnr_qrwaPiP14sqlnr_progress + 0x49
    
    
    Workaround: None
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * db2 v970                                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * DB2 MAY ABEND DUE TO MEMORY CORRUPTION WHILE ESTIMATING      *
    * STATISTICS.                                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * db2_v97fp4                                                   *
    ****************************************************************
    

Problem conclusion

  • Should not abend after upgrade to db2_v97fp4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC70474

  • 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

    2010-08-10

  • Closed date

    2011-05-04

  • Last modified date

    2011-05-04

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

    IC70404

  • 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 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC70474

Modified date: 04 May 2011