IBM Support

IC76524: UNDER RARE CONDITIONS, THE QUERY COMPILER FAILS TO HANDLE AN OUT OF STMTHEAP CONDITION

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Under rare conditions, during query compilation, the query
    compiler fails to handle an out of STMTHEAP condition. When the
    problem is encountered, you might observe one of the following
    outcomes:
    
    1. A trap in function sqlno_iext_idx_search_method, or
    sqlno_find_key_preds with a stack of:
    
    sqlno_iext_idx_search_method
    sqlno_find_key_preds
    sqlno_btree_preds
    sqlno_index_scan
    sqlno_crule_index_scan
     ...
    sqlno_top_qtb
    sqlno_each_qur
    sqlno_scan_qgm
    sqlno_planning_scan
    sqlno_planning_phase
    sqlno_exe
    sqlno_exe
    sqlnn_cmpl
    
    2. An error sqlcode -901.
    

Local fix

  • The likelihood of experiencing this problem is increased if the
    STMTHEAP database configuration parameter is set to AUTOMATIC (a
    
    feature available in DB2 starting with V9.5). If this is the
    case, modify STMTHEAP to a manual value without the AUTOMATIC
    attribute.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Problem Description above.                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version V9.7 Fix Pack 5.                      *
    ****************************************************************
    

Problem conclusion

  • First fixed in Version V9.7 Fix Pack 5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC76524

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

  • Closed date

    2011-12-08

  • Last modified date

    2011-12-08

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

    IC76523

  • 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 #: IC76524

Modified date: 08 December 2011